Reltio Connect

 View Only
  • 1.  Numeric Range RDM lookup or other options

    Posted 12 days ago

    Hi There,

    Please guide me on how to setup numeric Range RDM lookup based on another attribute value.

    For instance,

    Value between 1 and 10  --> Transcode to Small

    Value between 11 and 99 --> transcode to medium

    Value > 99  --> transcode to large

    I did ask RIA about this and it was able to identify a solution but the link to documentation is not working

    From RIA:

    Setting Up Numeric Range Lookups in Reltio

    No problem, I can help you with that! Setting up numeric range lookups in Reltio is a great way to improve the efficiency and accuracy of your data management. Here's how you can do it:

    1. Navigate to the Lookup Definitions page. You can find this under the Data Management section in the Reltio UI.
    2. Click on "Create New Lookup Definition." This will open a new window where you can configure your lookup.
    3. Select "Numeric Range" as the lookup type. This will allow you to define a range of values for your lookup.
    4. Enter the name and description for your lookup. This will help you identify and understand the purpose of the lookup later on.
    5. Define the range of values for your lookup. You can do this by entering the minimum and maximum values in the respective fields.
    6. Optionally, you can configure additional settings for your lookup. This includes things like the data source, the lookup cache, and the timeout value.
    7. Click on "Save" to create your lookup definition.

    Once you have created your lookup definition, you can use it in your data transformations and integrations. When Reltio encounters a value that falls within the defined range, it will automatically use the corresponding lookup value. This can save you a lot of time and effort, especially if you are dealing with large datasets.

     

    Here is the documentation link on how to setup numeric range lookups in Reltio:

    https://docs.reltio.com/reltio-cloud/user-guide/lookups/numeric-range-lookups/

    But the documentation link doesn't work and I never thought such an option exists in Reltio. Please guide us here.

     

    Thanks,

    Vish



    ------------------------------
    Vishvesh Reddy
    Onetrust
    ------------------------------


  • 2.  RE: Numeric Range RDM lookup or other options

    Posted 12 days ago

    Hi Vish,

    Follow the link.

    https://docs.reltio.com/en/explore/get-a-crash-course/get-ready-to-turn-your-data-into-action/learn-about-multidomain-mdm/lookups-for-attribute-code-values/dependent-lookups

    Thanks,

    RK



    ------------------------------
    Radhakrishnan Ramalingam
    Architect
    San Ramon CA
    ------------------------------



  • 3.  RE: Numeric Range RDM lookup or other options

    Posted 12 days ago

    Hi Radhakrishnan,

    Thank you for the post.

    The problem we are trying to solve is let's say we have 5 different orgs and based on revenue of the employees, we want to segregate the company type.

    Value between 1 and 10,000  --> Transcode to Small

    Value between 10,001 and 10,00,000 --> transcode to medium

    Value > 10,00,001  --> transcode to large

    The value can be in millions too and the above is just a reference.

    Thanks,

    Vish



    ------------------------------
    Vishvesh Reddy
    Onetrust
    ------------------------------



  • 4.  RE: Numeric Range RDM lookup or other options

    Posted 9 days ago

    Hi  Vish,

    This can be done through LCA or  RIH.

    Thanks,

    RK



    ------------------------------
    Radhakrishnan Ramalingam
    Architect
    San Ramon CA
    ------------------------------



  • 5.  RE: Numeric Range RDM lookup or other options

    Reltio Employee
    Posted 8 days ago

    to expand on that last post, you can have Relito Integration Hub(RIH) (or any other integration technology) listen to the queue, interogate the value of the revenue per employee (or whatever calculation you might want to make) and update your lookup.  you could also do this with an advanced query and then use the bulk update functionality via the Reltio UI.  If you do that you could call the API's periodically with a program you have written or RIH



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