Max FileName and Data Load

[profilejamesbond]

Hi,

I want to load max file data from the folder.

How to identify the max file from folder?

Example: input

File01.01.2022 to 02.02.2022

File01.01.2022 to 03.02.2022

File01.01.2022 to 04.02.2022 -> only this file data need to be upload.

File02.01.2022 to 02.02.2022

File02.01.2022 to 03.02.2022 -> only this file data need to be upload.

Example: output

File01.01.2022 to 04.02.2022

File02.01.2022 to 03.02.2022

[barnabyd]

G'day,

This requires a few steps. I'll briefly outline them and hopefully that will get you going.

1. load a list of file names in a folder. See this old article (it should still work).

2. parse the names of the files to get the dates by using something like this:

date( right( BaseFileName(), 10 ), 'DD.MM.YYYY' )

3. filter out the undesired dates

4. loop through the remaining rows in the table to load up each of those files

Cheers, Barnaby.