Now, I am loading a table which has the following columns: Timestamp, Alpha, Beta, Gamma, x,y andz. The requirement is that I have to load column Timestamp and only those columns present in the variable. i.e Alpha,Beta and Gamma in this case for which I am using the script the following script
Scenario: LOAD timestamp, $(vTagNames)
FROM [Scenario.xlsx] (ooxml, embedded labels, table is Sheet1);
This script is working fine but now I have a new requirement to read each TagName in one pass.
i.e. For the variable vTagNames.. in the first pass script should read Alpha, In the second iteration it should read Beta and in the third pass it should read Gamma and later join all three. How to do this?