topic Re: How to load files with dates in name in QlikView

How to load files with dates in name

mwscott1 — Wed, 25 Nov 2020 16:16:04 GMT

I have a file that is automatically generated and replaced everyday by a file with same file name except the date changes.

Example = NEW_AGENT_2016.09.22.TXT

I only need to pull current days file. Is there a way to do this without going in and updating the load statement everyday with the new file name?

LOAD [Agent Code],

[Agent Name],

[Curr Rep Type]

FROM

[\\FILE_LOCATION\NEW_AGENT_2016.09.22.TXT]

(txt, utf8, embedded labels, delimiter is ',', msq);

sunny_talwar — Thu, 22 Sep 2016 14:52:01 GMT

May be like this:

LET vDate = Date(Today(), 'YYYY.MM.DD');

LOAD [Agent Code],

[Agent Name],

[Curr Rep Type]

FROM

[\\FILE_LOCATION\NEW_AGENT_$(vDate).TXT]

(txt, utf8, embedded labels, delimiter is ',', msq);

Anonymous — Thu, 22 Sep 2016 14:52:23 GMT

you can define a variable

Let vtoday=date(today(),'YYYY.MM.DD');

and the use

load

FROM

[\\FILE_LOCATION\NEW_AGENT_$(vtoday).TXT]

(txt, utf8, embedded labels, delimiter is ',', msq);