Reltio Connect

 View Only

  • 1.  Need to implement DVF with if-else condition

    Reltio Partner
    Posted 10-18-2022 12:26
    Hi,

    Is there any way to implement DVF by applying if-else condition. Please find the requirement below for an example:
    "For US Country Phone Number should have only 10 digit number"

    ------------------------------
    Pradipta Chakraborty
    Cognizant Technology Solution (P) India Limited
    ------------------------------


  • 2.  RE: Need to implement DVF with if-else condition

    Reltio Employee
    Posted 10-19-2022 10:27
    Hi Pradipta,

    The Data Validation Function builder support more than one condition as can be seen from this screen shot:



    Although the example of a phone number is probably not the best as the OOB phone cleanser automatically takes care of that.

    ------------------------------
    Gino Fortunato
    Senior Solution Engineer
    Reltio
    ------------------------------

    Original Message


  • 3.  RE: Need to implement DVF with if-else condition

    Reltio Partner
    Posted 10-20-2022 02:25
    Hi Pradipta,

    Can not be possible through DVF
    DVF will not support length
    Based on your previous question, you might be having special characters in phone.number, in Reltio, not possible to extract only numbers(Ignore special characters) and check the length of that.

    Workaround
    1. As suggested by Gino, use phone cleanser, and cleanser populates the status column whether it is valid or Invalid, you can use this column t valida the phone number
    2. This suggestion will lead to multiple saved searches.
    in Data Quality Dashboard, Reltio provided the length statistics(length = 1, length =2, length =10 etc... based on the dataset)
    Select the phone.number, go to the length functionality, select the length, it will route to advanced search
    add Phone.country = US and save this  search.
    But unfortunately, you need to create lot of saved search and   for each length 


    ------------------------------
    Nagaraju
    PwC
    ------------------------------

    Original Message


  • 4.  RE: Need to implement DVF with if-else condition

    Reltio Partner
    Posted 10-20-2022 02:41
    Hi Pradipta,

    The requirement can be achieved.
    1. By default cleanser will provide the Digit count.
    2. Like Gino mentioned to have multiple conditions, first condition to have Phone Country as US and the next step would be to have DVF on Phone.Number.
    Since length is not a function available from drop down. You can try Regular Expression does not match and give it as digits as shown below:

    Hope this works.

    ------------------------------
    Sheshadri V
    Fresh Gravity
    ------------------------------

    Original Message