error in creating a folder name as feild in script

[bushpalaamarnat]

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);