Unify and manage your data

Pivoting attributes

Learn how to edit and define your pivoting attributes

A pivoting attribute in Reltio is a data attribute that serves as a key field for reorganizing, filtering, or analyzing data across different perspectives in the UI. It allows you to dynamically group, sort, or visualize data based on your specific entity attributes, enabling more interactive and insightful data explorations.
Edit your pivoting attributes
  1. Navigate to Console > UI Modeler
  2. Select Import/Export UI config files
  3. Find and export the com.reltio.plugins.pivoting.json file
  4. Open the exported file and locate the section with "id": "com.reltio.plugins.pivoting.PivotingSettings"
  5. Add or remove attributes from the array pivotingAttributes as needed.

    Each object inside pivotingAttributes contains:

    NameTypeDescription
    uriStringattribute URI.
    childrenArray.<String>attribute URIs. If pivoting attribute is nested, then we can specify which sub-attribute of it must be used in pivoting.
    popupObjectpivoting popup configuration:
    • label (String) - Pivoting popup caption.
    • entityType (String) - Entity type URI. Only entities of this type are shown on the popup.

    Here is an example:

    { "point": "com.reltio.plugins.ui.configuration", "id": "com.reltio.plugins.pivoting.PivotingSettings", "pivotingAttributes": [ { "uri": "configuration/entityTypes/HCP/attributes/FirstName" }, { "uri": "configuration/entityTypes/HCP/attributes/BirthCountry" }, { "uri": "configuration/entityTypes/HCP/attributes/Phone", "children": [ "configuration/entityTypes/HCP/attributes/Phone/attributes/Number", "configuration/entityTypes/HCP/attributes/Phone/attributes/Type" ], "popup": { "label": "Organizations", "entityType": "configuration/entityTypes/Organization" } } ] }
  6. Save the updated file.
  7. Import the modified file back into the system.
Your com.reltio.plugins.pivoting.json file is now updated with your defined pivoting attributes.