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
