Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to do something like this
for i=1 to 3sheet='Sheet' <- here I want sheet to be a 'Sheet1' in first iteration, 'Sheet2' in second etcLOAD field1, field2, field3FROM(ooxml, embedded labels, table is $(sheet));next i How can i do it?
Try this...
for i=1 to 3
let vSheet = 'Sheet$(i)';
LOAD TestFROMBook1.xlsx(ooxml, embedded labels, table is $(vSheet));
next