Have the ability to set advanced logic to merge criteria in Rules Engine
Userlevel 7
+1
It would be ideal to be able to add advanced filter logic to merge criteria when merging two datasets in bionic rules. This would allow us to reference two fields where the identifier could be present to merge the data on. Currently, we have to perform to separate merges for each criteria and then merge the reports together a third time to create a final dataset.
Userlevel 7
+1
Hi Samantha, I'm trying to understand your request a little more. Are you saying for example that you have Object A that has Field AA, and Object B that has Field BA and Field BB; and you want to merge the data if AA matches BA or BB?
Userlevel 7
+1
That is correct! This would result in a line with AA and BA merged together and a line with AA and BB merged together.
Userlevel 7
+1
But do you need separate lines for BA and BB or do you want to merge (union) the BA and BB sets together (like below)?
Userlevel 7
+1
I would want separate lines for BA and BB. This would solve for when an identifier can be present in two locations on a single object.
Reply
Login to the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.