Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I made new application in Qlik Sense. But each day I need update new data inside my app from new file. Folder is still same. Example. File name for today is ZLX02S_20170626_055500. Star letter are changeble: ZLX02S_********_0555**. Tomorrow can be something like ZLX02S_20170627_055522.
Old data I dont need, every day I need only actual last data.
So, I need only change in script load newest file. Its in Qlik any auto possibility, how to make it, or I need it do each day manual?
Thank you for your help.
Try something like this:
LET vDateString = year(today())&Num(month(Today()),'00')&num(day(today()),'00');
LOAD
*
FROM [lib://q/ZLX02S_$(vDateString)_0555??.txt]
(txt, codepage is 1250, no labels, delimiter is '\t', msq);
Load latest Excel file to Qlikview
You have to do some changes with file names..
Try something like this:
LET vDateString = year(today())&Num(month(Today()),'00')&num(day(today()),'00');
LOAD
*
FROM [lib://q/ZLX02S_$(vDateString)_0555??.txt]
(txt, codepage is 1250, no labels, delimiter is '\t', msq);
Of course assuming that there is only one file a day.
Thank you very much Tomasz. It work! When I see it wrote from you before me - so its simply, when Im thinking about it.
But make it wholle from nothing, from beginning, its really very hard. Im not strong in Qlik and scripts and variables are for me big unknown. Now I little bit understood variables, thanks to you. 🙂 Again thank you for your help.