topic Loading excels when date matches in QlikView

Loading excels when date matches

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

Hi,

I have two variables vMaxDate and vMinDate which has Max and min dates respectively.

For this particular dates the excel files should dynamically load.

For the excel files date field needs to be taken from filepath.

Any help on this?

Re: Loading excels when date matches

Anil_Babu_Samineni — Mon, 14 May 2018 04:41:25 GMT

Seems, i am not clear. Where and what you want to update with dates from that variables?

Re: Loading excels when date matches

jonathandienst — Mon, 14 May 2018 06:15:20 GMT

You will need to fill in the blanks as you have not provided very much to go on, but this is the general pattern:

For Each vFile in FileList('... the file path and filelist mask ...')

Let vDate = ... parse date from vFile ...;

If vDate >= vMinDate And vDate <= vMaxDate Then

LOAD ....;

End If

Next

Re: Loading excels when date matches

Anonymous — Mon, 14 May 2018 06:17:30 GMT

I'am calculating min and max variables from qvd, only for those dates I want to load excel files from a folder.

Re: Loading excels when date matches

Anonymous — Mon, 14 May 2018 07:10:29 GMT

This will load all excels for all dates but I need only for vMaxDate and vMinDate and not for in between dates

Re: Loading excels when date matches

vishalarote — Mon, 14 May 2018 08:05:31 GMT

load *,

from 'C/Filepath/*.qvd'

where Date>=Mindate and Date<=Maxdate;

Re: Loading excels when date matches

jyothish8807 — Mon, 14 May 2018 08:36:34 GMT

Hi Aparna,

Once solution could be if you can populate the date on the file name, so qlikview can identify the file using the file name. Else you have to load all the files and then exclude the unwanted one based on the Date field inside the file.

Br,

Re: Loading excels when date matches

jonathandienst — Mon, 14 May 2018 08:53:48 GMT

>>This will load all excels for all dates but I need only for vMaxDate and vMinDate and not for in between dates

Then just modify the If statement accordingly:

If vDate = vMinDate Or vDate = vMaxDate Then