Append rule results

Related products: None

Is there any way other than via merges and case statements to append 2 rule set outputs together without doing a merge? The option to merge date fields isn’t there and you can’t convert them to a string so I’m stuck. 

 

For example,

 

Rule 1 has Name, Email, System Name, Date

Rule 2 has Name, Email, System Name, Date

 

Need to Append Rule 1 and Rule 2 for a combined list of all results. Currently can’t because the “Date” field isn’t allowed for a case statement output type

Hi Andrew,
1.We can merge based on date fields.PFB Picture.


2. To convert Date to string we need to Export the rule results to an S3 file and reimport the file in a separate rule.while importing please select data type as string for that particular field.

Please correct me if am wrong.


Hi @aschreiner 

Yes, in rule merge tasks we can use the Date fields in join Condition.


Hi @aschreiner 

We are currently working on Union in our Data Designer in the next release. We have plans to bring Union capability in Rules Engine once its out in production as a part of our roadmap. 


Hi @aschreiner 

We are currently working on Union in our Data Designer in the next release. We have plans to bring Union capability in Rules Engine once its out in production as a part of our roadmap. 

@aschreiner hope this helps to you! Changing this to an idea post.

Thanks @rakesh!!  That’s a good news!!