Great to hear that the suggestion worked.
Original Message:
Sent: 07-19-2023 04:38
From: Rahul Rajan
Subject: Matching on all nested/reference attributes
Hi Sheshadri, Thank you for the info. Match cleansing (MultipleValuesCombinerCleanser) is working for both nested and reference as well.
Thanks,
Rahul Rajan
------------------------------
Rahul Rajan
Fresh Gravity
Original Message:
Sent: 07-18-2023 07:38
From: Sheshadri V
Subject: Matching on all nested/reference attributes
Hi Rahul,
You can try this option to Cleanse the values only while matching and even concatenate all the attribute values and form a separate attribute to use in matching.
The cleanse adapter used here is:
"cleanseAdapter": "com.reltio.cleanse.impl.MultipleValuesCombinerCleanser",
You can find the documentation link here:
https://docs.reltio.com/en/explore/get-a-crash-course/get-ready-to-turn-your-data-into-action/learn-about-multidomain-mdm/reltio-match-merge-and-survivorship/match-group-elements---description-and-configuration/rule-element/match-cleansers/value-concatenator-cleanser
I have tried this and it is working even for Nested with multiple values and matches only when they are exactly same after removing duplicates.
Please try out and update.
------------------------------
Sheshadri V
Fresh Gravity
Original Message:
Sent: 07-18-2023 02:59
From: Rahul Rajan
Subject: Matching on all nested/reference attributes
Hi Harsha, Thank you for your response.
In my use case, under substance we have strength and it has 16 attributes and these attribute needs to be consider for matching as well (same applicable for reference substance). We can have more than one substance and reference substance.
We thought to create Hash keys as well but the current structure is complex and it requires either LCA or RIH recipe or code to populate the attributes which will impact in performance and real times matches.
Thanks for your input again.
Thanks,
Rahul Rajan
------------------------------
Rahul Rajan
Fresh Gravity
Original Message:
Sent: 07-17-2023 11:55
From: Harsha Karumuri
Subject: Matching on all nested/reference attributes
Hi Rahul,
I believe there is no direct way to achieve this unless you have a predefined type for each substance.
I am not sure how you have configured your tenant on partial overrides for nested attributes and how many variations you have for your substances, but the following is an option that can be leveraged based on your use case,
Populate a new attribute that will have all the substances in asc or desc (with delimiter) and use that attribute in matching.
Please let me know if this helps or if you have any alternate solution.
Thanks,
Harsha Karumuri
------------------------------
Harsha Karumuri
Dodge Data and Analytics
Hamilton TownshiP NJ
Original Message:
Sent: 07-17-2023 04:13
From: Rahul Rajan
Subject: Matching on all nested/reference attributes
Hi Team,
We have requirement to match two PHP records based on exact values of all reference and all nested attributes.
For example : Php1 with 3 subtances (A,B,C) and referenceSubstance ( D,E,F) should have potential match with Php2 only when it has subtances (A,B,C) and referenceSubstance (D,E,F) (nothing more and nothing less)
PhP1 should not have potential match with Php3 if it has subtances (A,B,P) and referenceSubstance (R,S,T)
Please let us know if there is a way to achieve this?
Thanks,
Rahul Rajan
------------------------------
Rahul Rajan
Fresh Gravity
------------------------------