topic Re: new data in App Development

new data

Anonymous — Mon, 26 Jun 2017 13:29:12 GMT

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.

Re: new data

MK_QSL — Mon, 26 Jun 2017 13:33:46 GMT

Load latest Excel file to Qlikview

You have to do some changes with file names..

Re: new data

tomasz_tru — Mon, 26 Jun 2017 17:03:40 GMT

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);

Re: new data

tomasz_tru — Mon, 26 Jun 2017 17:04:10 GMT

Of course assuming that there is only one file a day.

Re: new data

Anonymous — Tue, 27 Jun 2017 14:22:34 GMT

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.