<< Click to Display Table of Contents >> Navigation: Reference > Transforms > Concat Cols |
Creates a new column by concatenating text from one or more existing columns.
One.
•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.
•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. The values are in the order of the columns. You can change the column order before concatenation with Reorder Cols.