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...
  • koryknick's avatar
    koryknick
    2 years ago

    I didn't notice before, but you don't want to have anything in the Multipart sub-type property.  Clear that $ from the expression and uncheck the expression enabler.

     

koryknick's avatar
koryknick
Employee
3 years ago
Copy LinkReport

@darshthakkar - the reason I was asking about the number of fields is that the Group By N is giving me the set of fields per object. If you increase that to consume the entire document, then creating the object would fail because you wind up with duplicate names in the object.

But I’m glad this is working for you!

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Copy LinkReport

Got it, thank you for sharing the additional details on this.