Forum Discussion

vaidyarm's avatar
vaidyarm
Contributor
5 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
Contributor
5 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