Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.