Need help to execute for loop

subathra — Thu, 26 Oct 2017 07:08:09 GMT

Hi all,

I have two tables

Table1:

Sitecode
3
4

Table2:

My Desired Output:

load Table2 where sitecode is 3 and store it in april_3.qvd

load Table2 where sitecode is 4 and store it in april_4.qvd

Error i am getting:

in april_3.qvd i get datas where sitecode is 3

but in april_4.qvd i get both sitecode 3,4(here i need only sitecode 4)

my script is:

SheetName1:

LOAD

Sitecode

FROM [lib://data/test22.xlsx]

(ooxml, embedded labels, table is Sheet1);

for iSheet = 0 to NoOfRows('SheetName1') - 1

let vSheetName1 = peek('Sitecode',iSheet, 'SheetName1');

Final:

LOAD

Sitecode,

Name,

Value

FROM [lib://data/test.xlsx]

(ooxml, embedded labels, table is Sheet1) where Sitecode='$(vSheetName1)';

Store Final into [lib://data/april_$(vSheetName1).qvd] (qvd);

Next iSheet

drop table SheetName1;

Re: Need help to execute for loop

tomasz_tru — Thu, 26 Oct 2017 07:43:18 GMT

Maybe this would help:

subathra — Thu, 26 Oct 2017 07:55:33 GMT

thanks Tomasz

subathra — Thu, 26 Oct 2017 08:20:43 GMT

Is there any other solutionns