Data for ADSL and DM variables can be merged into the Master PC worksheet.
-
At the bottom of the Map PC Variables page, click the Add ADSL or DM Variables button.
-
Use the Load Data button to select an ADSL and/or DM file external to Phoenix.
If a project is open in Phoenix, use the Load Data From Phoenix Project button to load the data from the Data folder. -
Use the ADSL and DM tabs at the top to switch between the two domains.
-
Click the Preview button at the bottom to show the merged data in the Master PC Worksheet at the bottom of the dialog.
Newly added columns of data will appended to the Worksheet table, so you may have to scroll to the last column(s) to see the data.
The following instructions are applicable in both tabs.
To add data columns
Use the “Include Columns” table to add columns from the ADSL or DM variable source file to Master PC worksheet.
-
Click in the Source Column cell and select the name of the source data column to add.
-
If needed, click in the Result Column cell and edit the name that will appear in the Master PC worksheet as the column header.
Click + to confirm the addition of the row to the “Include Column” table.
Click X to remove the associated row from the table.
To define join columns
Columns that are identified in the “Join Columns” table are used to connect the data being added with the appropriate subject by matching the values with those in the Master PC worksheet’s column with the same header.
-
Click in the Source Column cell and select the name of the source data column that contains the subject identifier information.
-
If needed, click in the Result Column cell and edit the name that will appear in the Master PC worksheet as the column header.
Click + to confirm the addition of the row to the “Join Column” table.
Click X to remove the associated row from the table.
