Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Thank you very much!
Please mark as helpful or correct answer if it works