Discussion board where members can get started with Qlik Sense.
I have used below code to fetch all the excel files under single folder and its running fine but now i need to change it like
2019 | Feb| a.xlsx|b.xlsx|c.xlsx etc
but now sheet a and c starts with header 2 and B sheet with header 3 then how to change the existing code and store it into qvd.
let vYear= Year(Today());
For each FileExtension in 'xlsx'
FOR Each FoundFile in FileList(Root &'\*.'& FileExtension)
// Calling Variable For current year
(ooxml, embedded labels, table is Tabelle1);Next FoundFile
For Each SubDirectory in DirList (Root & '\$(vYear)\*' )
Call ScanFolder('lib://SharePath(ho_a)') ;
I will be grateful for any help!
Many thanks in advance!