File Arrival dates

raadwiptec — Tue, 17 May 2022 19:13:47 GMT

Hi all,

I have a requirement where we recieve everyday a csv file Ex:

Source_10052022.csv, Source_11052022.csv, Source_12052022.csv, Source_13052022.csv, Source_14052022.csv

10the dated file we recieve on 11, 11th day file we recieve on 12th. Todays data we recieve tomorrow .

The Files are saved in a directory everyday

we want to have a table as below to control. any ideas

Re: File Arrival dates

MarcoWedel — Tue, 17 May 2022 20:49:05 GMT

You could derive the date from the filename, link to a master calendar and count files per date.

raadwiptec — Wed, 18 May 2022 08:16:24 GMT

Hi Marco,

The idea is to prove that we have recieved the files of the previous day.