Hello,
using a lookup activity, I can loop through each row in on-prem sql table and get each of the field values separately...
usingthe query this is what I am doing:
select * from eol.configTable where Source = '@{pipeline().parameters.pSource}' and Check = '@{pipeline().parameters.pCheck}'
This time I would like to loop through a csv file instead of a sql table?
I have a dataset pointing to the csv in the blobstorage.
Question:
How do I do the same select query as there is no query option when dataset is csv?
Thank you