omiaye
2 years agoNew Contributor II
Automating data chunking date file
I am reading a file in a pipeline to break a data load into six-month increments. Twice a year, I need to update the file to accommodate dates for the next six months. My question is this: is there a way to build this date increment logic into my snap and avoid using this file? Thanks.
Current file format:
Start Date, End Date
2021-01-01, 2021-06-30
2021-07-01, 2021-12-31
2022-01-01, 2022-06-30
2022-07-01, 2022-12-31
2023-01-01, 2023-06-30
2023-07-01, 2023-12-31
2024-01-01, 2024-06-30