dynamic loading files

[#1]

Hi All,

How to load these files dynamically?

EAST_SAL_2016.xls

EAST_COMM_2016.xls

WEST_SAL_2016.xls

WEST_COMM_2016.xls

NORTH_SAL_2016.xls

NORTH_COMM_2016.xls

SOUTH_SAL_2016.xls

SOUTH_COMM_2016.xls

Thanks in advance.

[beck_bakytbek]

Hi Jack,

check this Video: QlikView - Loading Data From Multiple Files - YouTube

i hope that helps

beck

[jagan]

Hi,

Load the data with 2 load statements

Salary:

LOAD *,

FileName() as FileName,

FROM

*SAL*.xlsx

   (ooxml, embedded labels, table is [$(*)]);

Commission:

LOAD *,

FileName() as FileName,

FROM

*COMM*.xlsx

   (ooxml, embedded labels, table is [$(*)]);

Hope this helps you.

Regards,

jagan.