Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

error in creating a folder name as feild in script

Capture.PNG

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

ALL:

Load *,

Subfield(Dir,'\', NumberOfTimes + 1) as FolderName;

LOAD

FileDir() as Dir,

substringcount(FileDir(),'\') as NumberOfTimes

FROM

(ooxml, embedded labels);

STORE ALL into (qvd);

0 Replies