Load data multiple excel but number column different qlik sense

[salim]

Hello everyone ,

I'd like first, to thank everyone, who would take time to read this questions, and reply to it.

I'm trying to load 4 files excel : 

• Production_2020_11
• Production_2020_12
• Production_2021_01
• Production_2021_02

In the 2 first files we have 2 fields : Name and note 

In the 2 last files we have 3 fields : Name, note and prime

For load these files, I have to create a variable for search  date in title  : 

Set vProddate = Date (MonthEnd('01' & '/' & Num(Mid(FileName(),17,2)) & '/' & Num(Mid(FileName(),12,4))),'DD/MM/YYYY');

With this variable, I have to load data  in the 2 first files if I'm in 2020 or before and other for 2021 or more.

I tried to start with that : 

Set vProddate = Date (MonthEnd('01' & '/' & Num(Mid(FileName(),17,2)) & '/' & Num(Mid(FileName(),12,4))),'DD/MM/YYYY');

LOAD

FileName() as Production,
$(vProddate),

If($(vProddate) <= 01/01/2021,1

FROM [lib://AttachedFiles/Production*.xlsx]
(ooxml, embedded labels, table is Sheet1);

Please can you help me ?

Thanks

[JordyWegman]

Hi Salim,

Not really sure what you are trying here. Do you just want to load all the files? Or only a couple of them based on a date?

Jordy

Climber