Solved
How to split date into multiple rows from one row based on specific condition
Hi
I need to form multiple records from one row based on date criteria, and the criteria are that when start date and end date have a difference of more than 1 year, it should have multiple rows f...
I just tried to build on top of your logic to create the above scenario, was able to do it, refer to the attached pipeline, although design-wise it may not seem that cleaner and concise but it serves the purpose and handles the leap year exception as well
Input:Output:
It was helpful for contract management problems we have come across so far.
Contract_Date_splitter_2021_10_11.slp (23.2 KB)
