Cross-Table Column References

Cross-table column references let one table inside a Workbook pull data from a column in another table in the same Workbook. Use them to chain tables together so output from step one becomes input for step two.

Coming soon: Workbooks are not yet available in all accounts. This article covers how they will work when the feature rolls out.

Before you begin

• Both tables must be inside the same Workbook.
• The source table must have at least one column with a data type that matches what the destination table needs.

Add a cross-table column reference

1. Open the destination table (the table that will receive data from another table).
2. Click Add Column.
3. Select Cross-Table Reference as the column type.
4. Choose the source table from the dropdown.
5. Choose the source column from the dropdown.
6. Click Save.

The column populates with data from the source table, row by row. Rows are matched by their position in the table unless you configure a key-based match.

Key-based row matching

By default, row 1 in the destination table pulls from row 1 in the source table. If your tables have different numbers of rows or rows in a different order, use key-based matching.

To configure key-based matching:

1. Open the cross-table column configuration.
2. Toggle on Match by key.
3. Select the key column in the source table (e.g., LinkedIn URL, Email, Company Domain).
4. Select the corresponding key column in the destination table.
5. Click Save.

TexAu will match rows where the key values are equal, regardless of row position.

Common pattern: LinkedIn URL as the shared key

Most enrichment workflows use LinkedIn URL as the shared key across tables:

• Table 1: Scrapes LinkedIn profiles - outputs LinkedIn URL, name, headline.
• Table 2: Finds emails - uses LinkedIn URL as input. Add a cross-table reference to pull the LinkedIn URL from Table 1, keyed on LinkedIn URL.
• Table 3: Finds phone numbers - same pattern, matched by LinkedIn URL.

This way each table can run independently or in sequence, and all results stay linked to the same contact.

Update behavior

Cross-table references reflect the current state of the source table at the time the destination table runs. They do not update in real time. If the source table is re-enriched, run the destination table again to pull in the new values.

Troubleshooting

Cross-table column shows blank values for some rows. If you are using key-based matching, the key value in the destination table may not match any key in the source table. Check for formatting differences - trailing spaces, different URL formats, or case differences can prevent a match. Use a formula column to normalize the key before matching.

The source table dropdown does not show all expected tables. Only tables inside the same Workbook appear as options. Tables in other Workbooks or standalone tables are not available. Move the source table into the same Workbook if it is not already there.

Key-based match is returning wrong rows. Verify that your key column contains unique values. If the same LinkedIn URL or email address appears in multiple rows, the match may return the first matching row rather than the intended one. Deduplicate your source table before running.