Extract Multiple SmartSheets into qlikview with in loop ?

[madhubabum]

Hi All,

I want to extract multiple smart sheets into qlikview with in loop

Note : Smart sheets are having unique names.

How we can store these Smart sheets into QVD format with in loop ?

Regards,

Madhu

[amars]

Hope u wish to read from multiple sheets. Kindly refer the below thread for code which reads from multiple files from multiple tabs

Issue with deploying code reading multitab excel

Thanks...

[Gysbert_Wassenaar]

Assuming you already know how to load data from smartsheets, create a table with the names of all the smartsheets. Then loop through that table, retrieve the name of the smartsheet and load the data from a smartsheet, store it into a qvd, retrieve the name of the next smartsheet etc. Something like this:

For i = 0 to NoOfRows('TableWithSmartSheetNames') -1

LET vName = Replace(peek('NameWithSmartSheetNames',$(i),'TableWithSmartSheetNames'),' ','_')

[$(vName)]:

LOAD * FROM [$(vName)];

STORE [$(vName)] INTO $(vName).qvd;

next