Discussion Board for collaboration related to QlikView App Development.
I am trying to create a folder name as a field in the script and synthetic key are creating and data is not created.
Could you please advise how to use folder name as a field in the script and load all the file in the folder
Subfield(Dir,'\', NumberOfTimes + 1) as FolderName;
FileDir() as Dir,
substringcount(FileDir(),'\') as NumberOfTimes
(ooxml, embedded labels);
STORE ALL into (qvd);