Forum Discussion

vaidyarm's avatar
vaidyarm
Contributor
4 years ago
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...
  • vaidyarm's avatar
    vaidyarm
    4 years ago

    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)

vaidyarm's avatar
vaidyarm
Contributor
4 years ago
Copy Link

Thanks @tlikarish ,

This one looks sleek but the problem is that I can have more than the “ID” column in the source, and since you have hardcoded the fields, it would be difficult to incorporate that.
but this one will be a good one when we have a fixed list of fields coming from the source

Thanks