Reltio Connect

 View Only
  • 1.  Custom Requirement | Brainstroming

    Posted 07-05-2023 05:57

    Hi Team,

    I have a recent requirement to map the data based on the value for a particular attribute.

    Example - Categories which is needed are as below
      * 0-250
      * 251-500
      *501-1000
      *1001-2500
      *2501-5000
      *5001-10000
      *10000+

    Need to bucket data based on the values such as 
    Example 1 - Value is 1450 then value should be routed as 1001-2500
    Example2 - Value is 345 then bucket should be routed as 251-500

    Any thoughts on the above .?

    Thanks & Regards,



    ------------------------------
    Chetan P
    Lead MDM Specialist
    Freshworks
    Chennai
    ------------------------------


  • 2.  RE: Custom Requirement | Brainstroming

    Posted 07-12-2023 02:26

    @Sheshadri V  - Any idea on the above .? Whether this can be implement through RIH or any other means.?



    ------------------------------
    Chetan P
    Lead MDM Specialist
    Freshworks
    Chennai
    ------------------------------



  • 3.  RE: Custom Requirement | Brainstroming

    Reltio Employee
    Posted 07-12-2023 09:29

    @Ayan Basu  any thoughts around this or know someone that might? 



    ------------------------------
    Chris Detzel
    Director of Customer Community and Engagement
    Reltio
    ------------------------------



  • 4.  RE: Custom Requirement | Brainstroming

    Posted 07-14-2023 03:22

    Thanks @Chris Detzel for pitching in.

    @Ayan Basu - i tried to implement this using RIH's (Snowflake connection with custom sql). Any thoughts for having this implement in a more optimised way.

    Thanks & Regards,



    ------------------------------
    Chetan P
    Lead MDM Specialist
    Freshworks
    Chennai
    ------------------------------



  • 5.  RE: Custom Requirement | Brainstroming

    Reltio Partner
    Posted 07-17-2023 07:57

    HI Chetan,

    I was OOO previous week and thanks for tag.

    This is very simple to achieve:

    Here the sample represents data in Integer and can be checked with conditionals.

    I tried all your scenarios and gave me perfect answer. Try out and update.



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



  • 6.  RE: Custom Requirement | Brainstroming

    Posted 07-18-2023 02:50

    Thanks for the response @Sheshadri V.
    I have implement this through Snowflake connection, but it is great to see this can be implemented via Variable explorer.

    Will try this out and choose which is optimised for the code and deploy the same.

    Regards,



    ------------------------------
    Chetan P
    Lead MDM Specialist
    Freshworks
    Chennai
    ------------------------------



  • 7.  RE: Custom Requirement | Brainstroming

    Reltio Partner
    Posted 07-18-2023 02:55

    Hi Chetan,

    We don't have to define any variable, i tried to replicate your scenario.

    You can have the same datapill from snowflake instead of variable.

     



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



  • 8.  RE: Custom Requirement | Brainstroming
    Best Answer

    Posted 07-19-2023 04:17

    Sure thanks for the response Sheshadri. I have planned using Snowflake connector so that i can also incorporate any other custom transformations as well.

    Thanks & Regards,



    ------------------------------
    Chetan P
    Lead MDM Specialist
    Freshworks
    Chennai
    ------------------------------