Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
alakazam
New Contributor III

new data

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.

1 Solution

Accepted Solutions
tomasz_tru
Valued Contributor

Re: new data

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

4 Replies
MVP
MVP

Re: new data

Load latest Excel file to Qlikview

You have to do some changes with file names..

tomasz_tru
Valued Contributor

Re: new data

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

tomasz_tru
Valued Contributor

Re: new data

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

alakazam
New Contributor III

Re: new data

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.

Community Browser