Sparkflows have "Concat Columns" processor that can be used to concatenate multiple columns as a single column. For example :
- If we have 2 columns, one with first name and another column with last name, and we want one single column which contains the Full name = first name + last name then we can use the "Concat Columns" processor to concatenate both the columns into one single columns.
Now, let us try to understand the configuration settings.
Configuration Window
- Select the columns which you want to concatenate. In our example, we have selected Name, Sex, Age columns.
- Enter the Concatenated Column Name.
- Define the separator which separates values of selected columns.
Our Input Data looks like below:
Input Data
After executing the workflow, output would look like below:
Concatenated column
Thus, 3 columns were concatenated into a single column.
Hello Lily,
Sparkflows have "Concat Columns" processor that can be used to concatenate multiple columns as a single column. For example :
- If we have 2 columns, one with first name and another column with last name, and we want one single column which contains the Full name = first name + last name then we can use the "Concat Columns" processor to concatenate both the columns into one single columns.
Now, let us try to understand the configuration settings.
- Select the columns which you want to concatenate. In our example, we have selected Name, Sex, Age columns.
- Enter the Concatenated Column Name.
- Define the separator which separates values of selected columns.
Our Input Data looks like below:
After executing the workflow, output would look like below:
Thus, 3 columns were concatenated into a single column.