Original Message:
Sent: 05-31-2023 01:31
From: Chetan P
Subject: Survivorship Rules | Custom list
I haven't tried the Sortas option on this one.
Any reference link or additional information on utilising this feature will help me Sheshadri.
------------------------------
Chetan P
Lead MDM Specialist
Freshworks
Chennai
------------------------------
Original Message:
Sent: 05-29-2023 03:14
From: Sheshadri V
Subject: Survivorship Rules | Custom list
Hi Chetan,
Can you shows us the config and what type of sort is applied here:
Let's say if we have above values then we can use sortAs as Number based and provide Min Value so that we may get the highest
Ex: 1-10 gives -9 and 11-50 gives -39 so the Min provides -39 and winner would be 11-50.
But the issue is with 10000+ as it can be read as integer.
You can try out the sortAs if not already tried and we may have to take off the + character so that we do not get any error.
------------------------------
Sheshadri V
Fresh Gravity
Original Message:
Sent: 05-29-2023 02:44
From: Chetan P
Subject: Survivorship Rules | Custom list
Hi Sheshadri,
I have already tried this method where even it uses lexicographical method, does't give output as expected.
For example - Values entered :
Value 1 : 1-10
Value 2 :11-50
Value 3 :51-250
Value 4 :251-500
Value 5 :501-1000
Value 6 :1001-5000
Value 7 :5001-10000
Value 8 :10000+
The above stated are expected values, but when comparing these value, expected output should be (10000+) but what i get is (51-250). I am still Looking a way to solve this.
------------------------------
Chetan P
Lead MDM Specialist
Freshworks
Chennai
Original Message:
Sent: 05-29-2023 02:27
From: Sheshadri V
Subject: Survivorship Rules | Custom list
Hi Chetan,
You can still use Min/Max value as it extends to Numbers, strings as well.
Let's say the attribute is string, then the Min/Max value uses 'lexicographical' sort so for the below input:
'20-30 (Priority 3)', '0-10 (Priority 1)', '40-50 (Priority 5)', '30-40 (Priority 4)', '10-20 (Priority 2)'
the output order would be :
'0-10 (Priority 1)', '10-20 (Priority 2)', '20-30 (Priority 3)', '30-40 (Priority 4)', '40-50 (Priority 5)' for min and
'40-50 (Priority 5)', '30-40 (Priority 4)', '20-30 (Priority 3)', '10-20 (Priority 2)', '0-10 (Priority 1)' for max value
So the winner will be
'0-10 (Priority 1)' for Min and
'40-50 (Priority 5)' for Max
I would suggest you to go ahead and have Max value so that the winner is always max value.
You can check additional details here:
Survivorship Rules | Reltio
Please try out and update here.
------------------------------
Sheshadri V
Fresh Gravity