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
| Date |
Filename |
Received |
| 01/05/2022 |
Source_31042022.csv |
Yes |
| 02/05/2022 |
Source_01052022.csv |
Yes |
| 03/05/2022 |
Source_02052022.csv |
Yes |
| 04/05/2022 |
Source_03052022.csv |
Yes |
| 05/05/2022 |
Source_04052022.csv |
Yes |
| 06/05/2022 |
Source_05052022.csv |
Yes |
| 07/05/2022 |
Source_06052022.csv |
Yes |
| 08/05/2022 |
|
No |
| 09/05/2022 |
Source_08052022.csv |
Yes |
