query multiple columns

asked on February 24, 2015

I'm trying to use the query data activity to query multiple columns in an excel spreadsheet. I have 3 separate lookups I need to do - OrgKey to find the file name, Program to find the program abbreviation and Doc type to find the doc type abbreviation. I tried to put these into one query activity, but it won't find any results that way. Are the additional queries excluding information? I.E. when I add the program columns to OrgKey, is it looking for one row that contains both values?

Do I have to separate these into separate queries? I hate to have 3 queries looking at my spreadsheet. This workflow is designed to rename large quantities of files, so I intend to drop 100+ at a time and have this workflow rename them based on the metadata. Any suggestions on how to make this efficient? Thanks!

0 0

replied on February 24, 2015

If you add 3 criteria to your query, then, yes, it will be looking for rows matching all 3.

Side note: Excel only allows one connection at a time to spreadsheets, so your workflow will not be able to process multiple documents simultaneously.

0 0

replied on February 24, 2015

Yeah, I found that out too. We are looking at using a SQL database, as we probably should be. Thanks for clearing that up, Miruna. I thought that was the case, but it seems quite inefficient to have to use 3 queries to get these pieces of info.

0 0

replied on February 24, 2015

Is there a way to tie those values together? Maybe with a SQL view?

0 0

replied on February 25, 2015

I don't think so. There are several hundred of one of the lookups. I will try to see if that might work, but I'll just go with 3 queries for now and make it pretty later. Thanks, Miruna.

0 0

Question

Question

Replies

Sign in to reply to this post.