importing data same content, different language

[#1]

Hello there,

I am currently working on 5 excel sheet that i need to update regularly...for the moment, i am saving all of them in one big file...is there a way to directly download all the them with a specific Scripting line instead of compiling them ?

LOAD Nom,
Prénom,
[Adresse e-mail],
Status,
Langue,
[Champ libre 1],
[Champ libre 2],
Pays,
Date(Floor([Date de création])) as Date,

Time(Frac([Date de création])) as Time

FROM

(ooxml, embedded labels);

thanks for your help

[Colin-Albert · Accepted solution]

Have you tried using a wildcard in the filename?

The column labels will need to be the same, or you will need to use the column numbers.

FROM

(ooxml, embedded labels);

[Gysbert_Wassenaar]

Perhaps with a wildcard load: Qlik_onec_*.xlsx

LOAD Nom,
Prénom,
[Adresse e-mail],
Status,
Langue,
[Champ libre 1],
[Champ libre 2],
Pays,
Date(Floor([Date de création])) as Date,
Time(Frac([Date de création])) as Time
FROM

(ooxml, embedded labels);

[zhadrakas]

Hello Jean-Phillipe,

yes you can use * in your FROM Statement

hope this helps

[#5]

i did not think about it thanks great idea