Hi, I've been trying to use the output from a lookup as input to another lookup. In the first lookup i have the name of the files to search:
I have a query with field names on a column like this:
field1 name1 name2
then, i search field1 in a lookup with a column with file names like this:
| lookup wheretosearch.csv field1 OUTPUTNEW lookup_name
my lookup wheretosearch.csv looks like this
field1 lookup_name name1 name1_lookup.csv name2 name2_lookup.csv
Then, I need that field lookup_name to search in a lookup for each row:
| lookup lookup_name ....
But obviously, this is not possible because the variable lookup_name is not the name of a csv file. How can i do this?
... View more