Forum Discussion
Solved
How to selectively choose days based on folder structure within parameters?
I have folders structurized like that: AmortizedCosts\ Daily\ 2025\ 04\ Fct_EA_AmortizedCosts_04.01.2025.csv Fct_EA_AmortizedCosts_04.02.2025.csv 05\ ... Monthly\ 2025\ Fct_EA_AmortizedCos...
Ok solution will be:
- Introducing 4 parameters:1) Granularity : monthly, daily, yearly
2) Year
3) Month
4) Day
If user will choose Daily granularity, he can put as Days parameter 1, 2, 3-5 so it means that for given year and month it will select partitions like 2025, 04, and days : 1,2, 3,4, 5.
So based on this i can selectivly choose which data has to be imported.
Best,
Jacek
Ok solution will be:
- Introducing 4 parameters:
1) Granularity : monthly, daily, yearly
2) Year
3) Month
4) Day
If user will choose Daily granularity, he can put as Days parameter 1, 2, 3-5 so it means that for given year and month it will select partitions like 2025, 04, and days : 1,2, 3,4, 5.
So based on this i can selectivly choose which data has to be imported.
Best,
Jacek