Reltio Connect

 View Only
  • 1.  Copy over the value from a reference attribute to a simple attribute inside same entity

    Posted 08-21-2024 03:21

    Hi ,

    We have a requirement to copy over the value from a reference attribute to a simple attribute inside same entity.

    We tried the String Cleanse Function as below but that is not working :-

     

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

     

    Could you please let us know how to achieve this requirement ?



    ------------------------------
    Utsa Das
    Novartis
    ------------------------------


  • 2.  RE: Copy over the value from a reference attribute to a simple attribute inside same entity

    Reltio Employee
    Posted 08-26-2024 08:23

    You can try using the Pattern Based Cleanser.

    https://docs.reltio.com/en/model/cleanse-data/cleanse-and-standardize-data-overview/out-of-the-box-cleanse-functions/pattern-based-cleanser

    Below is an example:

    {
                            "uri": "configuration/entityTypes/Individual/cleanse/infos/CleanserStatusBuilder",
                            "useInCleansing": true,
                            "sequence": [
                                {
                                    "chain": [
                                        {
                                            "cleanseFunction": "PatternBasedFieldBuilder",
                                            "resultingValuesSourceTypeUri": "configuration/sources/ReltioPatternCleanser",
                                            "proceedOnSuccess": false,
                                            "proceedOnFailure": true,
                                            "mapping": {
                                                "inputMapping": [
                                                    {
                                                        "attribute": "configuration/entityTypes/Individual/attributes/Address/attributes/VerificationStatus",
                                                        "mandatory": true,
                                                        "allValues": false,
                                                        "cleanseAttribute": "CleanseStatus"
                                                    }
                                                ],
                                                "outputMapping": [
                                                    {
                                                        "attribute": "configuration/entityTypes/Individual/attributes/AddressStatus",
                                                        "mandatory": true,
                                                        "allValues": false,
                                                        "cleanseAttribute": "OutputText"
                                                    }
                                                ]
                                            },
                                            "params": {
                                                "pattern": "{CleanseStatus}",
                                                "isForce": true,
                                                "ovOnly": true
                                            }
                                        }
                                    ]
                                }
                            ]
                        }



    ------------------------------
    Bryant Barrenechea
    Solution Architect | Professional Services
    ------------------------------