Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am currently loading multiple QVDs(12 QVDs for each month) via for Loop in script. Filenames are like:
ABC_2019_01, ABC_2019_02 ..... and so on.
FOR EACH vFile in FileList('ABC_*.qvd')
Load * FROM $(vFile)(qvd);
Next vFile;NEXT vFile;
Till now it works fine. Now I want to read the latest filename (e.g. - 'ABC_2019_09') and store this QVD File Name in a temp table.
Can anyone help me with an example script for this
Go to Solution.
'$(vFile)' as FileName,
QvdNoOfRecords('$(vFile)') as NoOfRecords,
QvdNoOfFields('$(vFile)') as NoOfFields
View solution in original post
Thanks a lot. This helps alot
That's great to hear.
I usually do something like this for every qvd I store in my extract and transform applications.