topic Re: Extract Multiple SmartSheets into qlikview with in loop ? in QlikView

Extract Multiple SmartSheets into qlikview with in loop ?

madhubabum — Thu, 05 May 2016 10:20:43 GMT

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

Re: Extract Multiple SmartSheets into qlikview with in loop ?

amars — Thu, 05 May 2016 10:32:26 GMT

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...

Re: Extract Multiple SmartSheets into qlikview with in loop ?

Gysbert_Wassenaar — Fri, 06 May 2016 10:45:54 GMT

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;