Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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?
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?
hello,
Yeah, u r right
IN the shhet name, we hace the month and year changing everytime
Thank you so much