How to split date into multiple rows from one row based on specific condition

[vaidyarm]

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 for each year date as mentioned below:

Input :

ID	StartDate	EndDate
1	2016-01-12	2019-11-30

Output :

ID	StartDate	EndDate
1	2016-01-12	2016-12-31
1	2017-01-01	2017-12-31
1	2018-01-01	2018-12-31
1	2019-01-01	2019-11-30

[SpiroTaleski]

@vaidyarm

I am attaching one possible solution, which is not perfect one, but hope it will cover your requirement.
Community_Child_2021_09_29.slp (3.8 KB)
Community_Parent_2021_09_29.slp (22.0 KB)
Regards,
Spiro Taleski

[vaidyarm]

vaidyarm:

2019-11-30

Have no words to thank you for this, I always thought to do such things via python script, but the core snaplogic solution you gave is very well thought !!

Thanks a lot !!

[tlikarish]

Here’s another option that uses a single pipeline that leans on the Expression Language to do most of the work.

row-split-example_2021_09_29.slp (9.1 KB)

[vaidyarm]

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