Virtually Join Data Tables

[#1]

If you want to merge related content in different data tables, save memory and time by joining them virtually. A virtual join links a main data table to one or more secondary data tables. The main table can then access data in the secondary tables without physically joining them.

To do a virtual join:

1. Open the tables that you want to virtually join.
2. In the secondary table that contains a unique identifier column to be linked to, right-click the column heading and select Link ID.
3. In the main table that has values that reference unique key columns in the other table, right-click the column heading and select Link Reference, then select the table it links to.
4. From the main data table, launch a platform. Referenced column groups appear in the launch window. Click a group to expand it, select columns, and run your analysis as usual.

Virtual Join