Hi All,
I have daily files in my SQL table with daily dates. I am pulling my current date file and last 6 days files separately from SQL.
Current Date Data + Last 6 Days Data. (it is a condition) which is treated as a single file.
However, I want to make it dynamic for my multiple files in SQL. Now I want to run for last 2023 year data. How can I make it dynamic?
The result should be picking files like this :
1. 13th Sep 2023 file + (last 6 days files: 12th,11th,10th,9th,8th,7th Sept)
2. 12th Sep 2023 file + (last 6 days files: 11th,10th,09th,8th,7th,6th Sept)
....................................................................................................
Any ideas / suggestions ?
