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.
Thanks@rakesh !! That’s a good news!!