topic Re: importing data same content, different language in QlikView

importing data same content, different language

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: importing data same content, different language

Colin-Albert — Wed, 04 May 2016 09:01:13 GMT

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);

Re: importing data same content, different language

Gysbert_Wassenaar — Wed, 04 May 2016 09:01:58 GMT

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);

Re: importing data same content, different language

zhadrakas — Wed, 04 May 2016 09:03:06 GMT

Hello Jean-Phillipe,

yes you can use * in your FROM Statement

hope this helps

Re: importing data same content, different language

Wed, 04 May 2016 09:43:21 GMT

i did not think about it thanks great idea