Reltio Connect

 View Only
Expand all | Collapse all

Can we have a Pattern Based Cleanser defined on top of the Cleansed Address attributes?

  • 1.  Can we have a Pattern Based Cleanser defined on top of the Cleansed Address attributes?

    Posted 08-21-2023 06:48

    We are trying to concatenate two attributes which are only mapped to the cleansed output of the Address Attribute. 

    In our case we expect the Organization and Delivery Address 1 cleansed output attributes from the Address attribute to have a pattern of
    {Oragnization} , {Delivery Address 1} on our Delivery Address Attribute. I have defined the pattern based cleanser for the same. But it is not yielding the desired output. Is there any setting on the physical configuration that needs to be set in order to achieve this functionality.

    Pattern Based Cleanser config:

    Not yielding expected results in Reltio :

    Note : The pattern-based cleanser worked on the simple attributes.

    Thanks,
    Rakshith.



    ------------------------------
    Rakshith Mahendra
    Lincoln Financials
    ------------------------------


  • 2.  RE: Can we have a Pattern Based Cleanser defined on top of the Cleansed Address attributes?

    Reltio Employee
    Posted 09-15-2023 23:50

    Hi Rakshith,

    Can you try using different values for the "resultingValueSourceTypeUri" field for address cleansing and for the generated pattern-based cleansed value? You are using "ReltioCleanser" as a source for address cleansing. Try using a different value for "resultingValueSourceTypeUri" field for PatternBasedFieldBuilder clenase.

     You can find examples of how to use different cleansers with Address cleansing in this documentation

    https://docs.reltio.com/en/model/cleanse-data/cleanse-and-standardize-data-overview/out-of-the-box-cleanse-functions/string-cleanser/using-string-function-cleanser-and-address-cleanser-together



    ------------------------------
    Suchen Chodankar
    ------------------------------