Load data based on max date

[rammuthiah]

I tried loading data based on max date from file name.

While trying to call in a variable, it's not working.

Is there any way to loa

[agigliotti]

could you provide a sample app with mock data ?

[agigliotti]

set vMaxDate = 0;

FOR Each File in filelist ('.\your_path\*.xlsx')

     set vFileNameDate = date#(left(FileBaseName(), 10),'YYYY-MM-DD');

     set vFileNameNumDate = num( replace( vFileNameDate, '-', '') );

     if $(vFileNameNumDate) > $(vMaxDate) then

          set vMaxDate = $(vFileNameNumDate);

          set vFileNameMax = FileBaseName();

     end if

NEXT File;

// finally load your last excel file

LOAD

...

from '$(vFileNameMax)'

(ooxml, embedded labels, table is Sheet1);

[rammuthiah]

For loop works fine for me

[rammuthiah]

For loop works well. Thanks for your hint