|
Appending Tables Using the Append Helper
The Append Helper is a wizard that can help you in customizing the append operation. Unlike other append methods, you can "force" Monarch Data Prep Studio to match columns even if they do not have the same location, name, and/or data type.
Appending tables using auto matching
Steps:
-
In the Prepare window table list, select the tables you want to append via the command Ctrl+Click.
-
Right click on your mouse and select Open Append Helper from the context menu that displays. The Append Helper displays:
-
If you wish to automatch columns, use the radio buttons located near the top of the dialog to select how to match columns and then click Auto Match Columns.
-
Name - This options matches all columns in both tables that have the same name (regardless of order). The output excludes columns that do not match. The schema adopted is that of the first table selected.
-
Name and Type - This option matches all columns in both tables that have the same name and type (regardless of order). The output excludes columns that do not match. The schema adopted is that of the first table selected.
-
By Order - This option matches all columns in both tables according to their order, regardless of name or type. The schema adopted is that of the first table selected.
Appending tables using manual selection
Steps:
-
In the Prepare window table list, select the tables you want to append via the command Ctrl+Click.
-
Right click on your mouse and select Open Append Helper from the context menu that displays. The Append Helper displays:
-
To match two columns with different names, use the drop-down icon to the right of the non-matching field of the corresponding table to locate the correct field to match. When the field is selected, the match is made.
-
The Output Columns panel displays which fields are displayed in the output table. By default, all automatic matches will be displayed. To add a manually matched field to the output table, tick to box corresponding to this field. You can change the data type and name of this field if you wish by clicking the Edit Name icon and then entering a new name into the activated name field and choosing a new data type from the data type drop-down, respectively.
Note that complete matches cannot be made if the data types of the fields being matched are different (e.g., Gender field in the figures above). In this case, ensure that the data types are identical in the Prepare window and then relaunch the Append Helper to match the fields.
Related Links