Reload

[#1]

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.

[avinashelite]

Try like

Temp:

LOAD

Filename() as Latest_date

from

folder\*

Let vLatest = max(Latest_date);

LOAD *

from

Folder\$(vLatest).xls;

Drop table Temp;