Join

Typical uses include combining name or address components into a single column for uploading into a database.

Pick Columns – select a column by position letter (optionally By Name) to be included in the Join operation and Add it to the list.

Remove original columns – after creating a new column with the joined values, remove the original columns from the table.

New Column Name – enter a name for the new column that will be created containing the joined contents.

To Be Joined – the list of columns to be joined, in the order desired.

Delete – remove the selected column(s) from the list of columns To Be Joined.

Delimiter – select a delimiter to use between the values of the columns being joined. Optionally enter your own sequence of characters (may be more than one).

Ignore missing values – do not include a delimiter when one of the columns has no value.

Updated for v8.2.