Loading excels when date matches

[Anonymous]

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?

[Anil_Babu_Samineni]

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

[jonathandienst]

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

[Anonymous]

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

[Anonymous]

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

[vishalarote]

load  *,

from 'C/Filepath/*.qvd'

where Date>=Mindate and Date<=Maxdate;

[jyothish8807]

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,

KC

[jonathandienst]

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