Crosstable Excel File

[Ily]

Hello,

I'm beginner in qlik.

Whenever i load a new excel file , with same name , in the same path

I have to edit connexction and isert script to make it work again . Otherwise, ihad this error :

So i put the code générated by the script to make it work :

LOAD * FROM [lib://Prime_Actuariat (wafaassurance_i.fodail)/stat_DIM.xlsx]
(ooxml, embedded labels, table is STAT_DIM_06.22);

Is there any way to automatise this process and make it work all the time,, whenever i update the file ?

[Or · Accepted solution]

We can't see your source file, so it's hard to guess...

Is the sheet name changing? It appears to have the month and year in it, so that might be the issue?

[Ily]

hello,

Yeah, u r right 

IN the shhet name, we hace the month and year changing everytime

Thank you so much