Inforiver
EDITable
EDITable
  • Introduction to EDITable
    • Why EDITable?
    • Supported Database Connections
  • Get Started
    • EDITable Pre-requisites
      • Admin consent for EDITable's Entra ID
        • Basic consent
        • Full admin consent
    • Install EDITable
    • Add EDITable visual
  • Getting Data into EDITable
    • Connect to Data
      • Get data
      • Assign fields
      • Configuration Steps
        • Configure source
        • Configure Columns
        • Configure Type 2 SCDs (Optional)
    • Create a Table
      • Create From Scratch
      • Use Existing Table
      • Import Data
  • Working with EDITable
    • EDITable interface
    • Manage Columns
      • General
      • Constraints
      • Lookup and Relation
      • Display
      • Import/Export Configuration
      • Add Database Column
      • Insert Column
    • Column Access Control
    • Row Identification
    • Table Operations (Insert/Update/Delete)
      • Edit data
      • Bulk Edit
      • Find and Replace
      • Insert rows
      • Insert Column
      • Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
      • Reset Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Group Rows By
      • Summarize Column
    • Basic formatting
    • Conditional Formatting
  • Row Access Control
  • Approval Workflow
    • Review Changes - Workflow process
  • Type 2 SCDs
    • Configuring Type 2 SCDs in EDITable
  • Audit logs
  • Webhook
  • Display Settings
  • Commenting and Collaboration
    • Assign users & task status
    • View all comments & track changes
    • Comment Settings
  • Admin Portal & EDITable Console
    • Tables
    • Transaction Logs
    • Insights (Metrics)
    • Utility
      • Download Report
      • Pipeline
        • Power BI & EDITable deployment pipelines
        • Deployment in different destinations
        • Trigger deployment pipeline from external applications
        • Logs & other pipeline options
    • Manage Profile
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • EDITable managed DB
        • API token
    • Onboarding Actions
  • Formula and Functions
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEIF
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • LOG
      • MAX
      • MIN
      • PCT
      • POWER
    • Text formatting functions
    • Date functions
      • DATE
      • DATE.FORMAT
    • Other operators
  • Keyboard Shortcuts
  • Release Notes
    • EDITable - v1.7.5
    • EDITable - v1.7
    • EDITable - v1.6.5
    • EDITable - v1.6
Powered by GitBook
On this page
  • 1. Manual
  • 2. Distinct Values
  • 3. Lookup Table
  • 4. Lookup Visual
  1. Working with EDITable
  2. Manage Columns

Lookup and Relation

PreviousConstraintsNextDisplay

Last updated 6 months ago

EDITable allows you to configure any field in the table using the single-select input type. The lookup and relation field is specifically designed for setting up single-select type columns. In addition to manually configuring the dropdown options, EDITable offers an effective method for sourcing values from dimensions, even if they reside in a different table or data source, through the use of lookup tables.

You can also use the helper/lookup visuals to source values from a dimension. In summary, we have the following methods to configure the options:

  1. Enter the dropdown values manually.

  2. Set up the existing options as a dropdown list with distinct values.

  3. Source values from another table in a database, which is usually done for foreign key fields.

  4. Use lookup/helper visuals to source your values.

This section will provide a detailed procedure for configuring dropdown values for each method.

1. Manual

This method allows you to type in the dropdown options and labels manually.

Let us take an example where the Department ID field is set manually.

  1. Choose Single Select in the Input Type field for the Department ID. As soon as you choose, the 'Lookup & Relation' section gets enabled.

  2. Click on the link to configure.

  1. Click on the Manual option.

  2. Enter the options and labels as required.

  1. Click on Add to add further new options.

  2. Click on the bin icon beside an option, in case you want to delete it.

  3. Click Apply and then Save the configuration.

  1. You can now edit the table with the added dropdown options in the required field.

2. Distinct Values

If you choose this option, EDITable creates a distinct list of options from the existing values. In the table below, the Incentive field already contains the following values: Bonus and Commission. These two values are available throughout the field.

When you choose Distinct, these values become the options for the dropdown.

3. Lookup Table

EDITable lets you look up and source values from other tables.

  1. When you click Lookup, the below pop-up opens where you can enter the name of the schema, table, label, and the options from where the dropdown options should be sourced.

  1. Click Apply after entering all the details as shown below and then Save the configuration. EDITable fetches the values from the configured field in the table.

  1. Now you can enter the configured dropdown values in the table.

4. Lookup Visual

Using the helper lookup visual is a more effective way to source values from other tables. It simplifies the process compared to the previous lookup method and ensures access to the most current data. It involves the following steps.

Step 1: Importing the helper/lookup visual into Power BI

Step 2: Configuring the dimension into the visual

Step 3: Configuring the lookup table within EDITable with the helper visual details.

Step 1: Importing the helper/lookup visual

Step 2: Configuring the dimension into the visual

Configuring the visual is as simple as dragging the dimension you want to cross-reference into the Dimension field. Depending on the number of tables you want to source in your report, you can add multiple lookup visuals.

Step 3: Configuring the lookup table within EDITable with the helper visual details

Enter the visual and the column name from which the options should be fetched. Click Apply and Save.

You can now use the values in the table.

In the next section, we will look at the display settings.

The Inforiver Lookup visual works in tandem with EDITable (and Inforiver Matrix visuals). It can be downloaded for free from our and then imported into Power BI.

If you want to know the steps to import, you can refer to this .

To learn more about helper/lookup visuals, you can refer to this .

customer portal
link
blog
Manual:
Distinct Values:
Lookup Table:
Lookup Visual:
Manual entry of values
Single select Input type
Enter the options
Apply and Save
Selecting an option
Existing values in the table
Distinct dropdown values
Schema and table details
Lookup Table configuration
Selecting an option
Downloading the lookup visual from customer portal
Configuring the helper visual
Lookup table configuration
Selecting an option