Concat Cols

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Concat Cols

Description

Creates a new column by concatenating text from 1 or more existing columns.

 

Inputs

1.

 

Options

Check the columns you wish to concatenate.

Supply the Delimiter you wish to place between concatenated text (optional). For example ",".

Check keep empty if you wish to keep the delimiter for empty columns.

 

Notes

If there is a header, the header of the new column is formed from the header of the concatenated columns. You can Rename Col it.

Concatenating a single column makes a copy of the column.

The new column is added at the right end. You can change the column order with Reorder Cols.

 

See also

Split Cols