Reltio Connect

 View Only
  • 1.  How would you carry out only 1st letter(Initial matches) for 2 field values ONLY when 1 of the values is a single character and the other is a full string?

    Reltio Partner
    Posted 05-04-2021 16:44
    How would you carry out only 1st letter(Initial matches) for 2 field values ONLY when 1 of the values is a single character and the other is a full string? Example – How to match 2 values, when value 1= A and value 2= Apple .

    ------------------------------
    Asmita Datta
    Deloitte USI
    ------------------------------


  • 2.  RE: How would you carry out only 1st letter(Initial matches) for 2 field values ONLY when 1 of the values is a single character and the other is a full string?

    Founding Member
    Posted 05-05-2021 06:22
    You could try CustomMatchToken where regular expression to always pick first letter of the string can be configured as pattern.

    ------------------------------
    Ashish Rawat
    Fresh Gravity
    Bangalore
    ------------------------------



  • 3.  RE: How would you carry out only 1st letter(Initial matches) for 2 field values ONLY when 1 of the values is a single character and the other is a full string?

    Reltio Partner
    Posted 05-05-2021 16:31
    Hey Ashish,
    Thanks for the input... I did try the regex for taking out the initial only and matching, however the catch here is to match 2 values, for example- A with Adam or Bright with B etc.
    But in achieving the above we should not match Edward with Edison.

    Let me know your thoughts?

    Kind Regards,
    Asmita

    ------------------------------
    Asmita Datta
    Deloitte USI
    ------------------------------



  • 4.  RE: How would you carry out only 1st letter(Initial matches) for 2 field values ONLY when 1 of the values is a single character and the other is a full string?

    Reltio Employee
    Posted 05-06-2021 10:56
    Hi Asmitta,
    You should be able to combine this test via AND with a NOT Equals comparison on the Name attribute, to achieve the desired result, assuming I understand your problem correctly.
    Best regards,
    Matt

    ------------------------------
    Matthew Gagan
    ------------------------------



  • 5.  RE: How would you carry out only 1st letter(Initial matches) for 2 field values ONLY when 1 of the values is a single character and the other is a full string?

    Reltio Employee
    Posted 05-06-2021 15:04
    Hi Asmita,
    You can split the attribute in two parts using cleanse and regex, where one part will contain initial, and the second part will contain rest of the string, and then match them using exactOrNull.
    Thanks,
    Sumit

    ------------------------------
    Sumit Singh
    ------------------------------



  • 6.  RE: How would you carry out only 1st letter(Initial matches) for 2 field values ONLY when 1 of the values is a single character and the other is a full string?

    Reltio Partner
    Posted 05-14-2021 06:49
    Thanks Sumit... I think now we know the way out although still have to test out various scenarios. 

    This was posted on the community long back I guess, just so that various ideas could flow in :)

    Thanks again!

    ------------------------------
    Asmita Datta
    Deloitte USI
    ------------------------------