Ignite Discussions : Ask Questions, Find Answers, Share Expertise about Sparkflows
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
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.