Create Fields from folder names

AmCh — Thu, 05 Aug 2021 16:26:22 GMT

Hello All,

A. First step

I want to (1.) generate fields and (2.) name them as follow:

* I have a folder AB11 underthis path : C:\AB1\ AB11 containing folders 01_AB111 and 02_AB112

--> (2.) Names of the fields should be AB111 and AB112

** 01_AB111 contains now Excel files named 01_v1111 and 02_v1112

*** 02_AB112 doesn't contain Excel files

--> (1.) Values of field AB111 should be v1111 and v1112

--> (1.) Since 02_AB112 does not contain data files, the field AB112 has not to be created.

Output

AB111

v1111

v1112

B. Second step

* Excel files (e.g. 01_v1111 and 02_v1112) are structured as follow:

01_v1111

02_v1112

--> I want to generate the following table named AB111 :

Any help please?

Thanks in advance.

Beste regards,

Amor

topic Create Fields from folder names in QlikView