Description
Showing the various ways the 'columns-concatenation' adaptor can be used to concatenate columns with each other or with text.
Inputs
Outputs
data (
datatable
)column1+column2 into column3
data 2 (
datatable
)column1+column2 with hyphen delimiter, into column2 (overwriting original column2 values)
data 3 (
datatable
)prefix+column1+postfix (hyphen delimiter) into new column3
data 4 (
datatable
)prefix+column2+column1 (no delimiter) into column2 (overwriting original column2 values)