Reload

Wed, 10 Feb 2016 02:07:46 GMT

Hi Experts,

I have 3 Sheets in one folder names are like

1) 2016_02_05

2) 2016_02_06

3) 2016_02_07

4) 2016_02_08

2016_02_08 is the latest sheet.

i have loaded all sheets in QV and here i have loaded recent sheet is 2016_02_08 when i go for reload i need only latest sheet data.

who can i get.

Re: Reload

avinashelite — Wed, 10 Feb 2016 10:27:09 GMT

Try like

Temp:

LOAD

Filename() as Latest_date

from

folder\*

Let vLatest = max(Latest_date);

LOAD *

from

Folder\$(vLatest).xls;

Drop table Temp;