Reltio Connect

 View Only
  • 1.  How to Export Combination of attributes belonging to Organization and location entity in one file

    Posted 11-19-2021 09:09
    I tried exporting through advanced search functionality with Or option but the reports are generated separately for Organization and location entity.


  • 2.  RE: How to Export Combination of attributes belonging to Organization and location entity in one file

    Reltio Employee
    Posted 11-21-2021 09:58
    @Gino Fortunato can you help with this?


  • 3.  RE: How to Export Combination of attributes belonging to Organization and location entity in one file

    Reltio Employee
    Posted 11-21-2021 13:28
    Hi Mohammed,

    In Reltio, exports are usually by entity type.  So if your data model has organization and location as separate entities, the export will typically be at least two files.  If you are using the data export in the Reltio Console, by default there will be additional files as the files are created by thread.  But there is an option to have Reltio combine those threads into one file.  

    If your data model has address as a nested attribute you won't have this issue.  Since the address is part of the organization, the nested address will be exported with the organization.


  • 4.  RE: How to Export Combination of attributes belonging to Organization and location entity in one file

    Reltio Employee
    Posted 11-21-2021 13:37
    Hi Mohammed,

    Can you please expand on what you are doing?  For example, are you using the export from the console?  Does your data model use nested addresses or is address a separate entity type?  If so, does your organization entity have address as a reference attribute?


  • 5.  RE: How to Export Combination of attributes belonging to Organization and location entity in one file

    Posted 11-22-2021 05:13
    we have Organization entity and Location entity.

    Now we need to export the data with below set of attributes across two entities

    For example:
    Organization name, Location name, Payment details from location entity attributes which is not  a reference attribute 

    I tried exporting the report with this combination from Reltio Console UI by selecting the attributes from Location entity, organization entity and relation entity
    But it is generating 3 different exports instead of generating a single report with combination of Organization entity and Location entity columns


  • 6.  RE: How to Export Combination of attributes belonging to Organization and location entity in one file

    Reltio Employee
    Posted 11-22-2021 10:17
    Hi Mohammed,

    if you do not have the location entity as a reference attribute, you will not be able to do the export in one file via the UI, I don't know which implementation you are working on, but if the customer has Reltio Analytics or the Snowflake connector, your best option might be to export the data from there using SQL to join the Organization and Location data.