Reference Column

A reference column joins tables through matching columns and displays related data from another table directly within the current table. This allows you to access information from related tables without duplicating the data.

This article explains the steps to insert a reference column that references data from another table using an example.

Add Reference column#

Consider the following example: you add a reference column to the Products table that references and displays order dates from the Sales table.

1. To add a reference column, go to PowerTable > Insert Column > Visual Column > Add Reference Column.

2. In the side panel, enter a name for the column.
3. Use Input Type to select the column's input type based on what you want to reference. Depending on the chosen type, the reference columns are available for selection. For example, if you choose Date, all date columns will be available for selection.

4. Select the schema, reference table name, and the reference column to display. In this example, Sales is the reference table and Order Date is the reference column.

5. Enable Match multiple to retrieve multiple values from all matching records in the reference table.
6. Select the matching column between the current table and the reference table.

7. Select Save.

The reference column is added.

Match multiple records

Match multiple allows the reference column to retrieve values from multiple matching records in the reference table. The values are displayed

When disabled, the matching columns should identify a single latest record in the reference table. Enable this option when a record in the current table can be associated with multiple matching records in the reference table.