How to automatically load all Excel data using qlik sense desktop

[Anonymous]

I want to load all the excel tables in a folder, they have the same structure, but the names of the tables are different, how can I achieve them. Thank you.

[marinadorcassio1 · Accepted solution]

Hello,

LISTE:

LOAD

     FileBaseName() as FILES,

     FileName() as "FileName"

FROM YourFolder\*.*;

NoConcatenate

LISTE2:

LOAD

     distinct "FileName"

Resident LISTE;

Drop Table LISTE;

FOR EACH File in FieldValueList('FileName')

$(Include=YourFolder\$(File));

next;

You need to adapt a bit.

Regards,

Marina

[Anonymous]

Thank you very much!

[marinadorcassio1]

Please mark as helpful or correct answer if it works