Enrich Data

Join of the data tables based on connection by the key fields — analogue of the LEFT JOIN operation in SQL. The node performs the action similar to the Left join of the Join node but the number of joined tables is optional.

Ports

Input

• Main table is the left table to be joined in the context of the SQL queries terms.
• Joined table is the right table to be joined in the context of the SQL queries terms.
• Add another port enables to create new ports for the subsequent joined tables that will be automatically numbered.

Output

• Output data set: the table that contains fields of all tables supplied to the input ports, with the exception of the joined tables fields selected as the key ones. Prefixes can be optionally added to the field captions of the joined tables.

Wizard

• Key fields configuration area: it is required to select a checkbox in the column of the joined table opposite the main table field that must become the key one. It is required to select the field from the drop-down list by which the tables will be connected. Activated option makes available compatible fields that are not still connected with key fields of the main table, deactivated option enables to select any of the fields compatible by type.
• Use prefixes: selection of this checkbox enables to add prefixes to names and captions of the fields from the joined tables in the resulting table.
  • Name prefix: the prefix added to the name of the joined table fields is specified in this field. Composition of the name prefix conforms to the rules of Features of data set fields.
  • Caption prefix: the prefix added to the caption of the joined table fields is specified in this field. It is named according to Features of data set fields.

For example:

Let's consider three tables as an example. A person - the main table and two joined: City and District.

Main table:

Joined table:

Joined table 2:

Resulting table:

• Replacement by Exact Match
• Replacement by Regular Expression
• Replacement File Structure
• Substitution of the Values not Included into the Replacement Table