fetching excel file based on file name - Qlik Community

Report Inappropriate Content · ‎2013-03-05

Dear All,

I have an excel sheet that is generated on the daily basis and its get stored by the following name such as

reasoncode-01-02-2013

reasoncode-02-02-2013

reasoncode-03-02-2013

reasoncode-04-02-2013

reasoncode-05-02-2013

reasoncode-06-02-2013

reasoncode-07-02-2013

reasoncode-08-02-2013

now i have to fetch the data of the lastest date i.e reasoncode-08-02-2013 but tomarrow the the new file be generated by this name

reasoncode-09-02-2013 and it has to fetch latest file...

Please help me in this matter.

kaushiknsolanki · ‎2013-03-05

Hi,

Please find the attached zip file for solution.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!