Setting Variable from row in csv file

Yes, I found that a few hours ago. Thank you for all your help. My actual original issue was the Loop variable from the start. It just was not obvious to me at the time.

admin wrote:

What you need to do is to load the data from the excel file into the database.
Then you can use SQL to populate the list of variables.
Please keep us posted on your progress.


 

Please let me know if I should create a new forum post , do we still need to populate this via SQL as listed here or we can do this from CSV files purely?

You can loop over lines with in the file using loop action 

www.etl-tools.com/wiki/advanced-etl-proc...ns/file-loop-action/

The problem is that loop assigns data to a single variable per line. (<Loop Value>

In your case every line in the file contains multiple variables,
since you do no not to load data into the database you have write a script which will split <Loop Value> into multiple variables

Please start new topic