I have been given a list of emails that I want to transpose—converting the data from rows to separate columns—and then concatenate these columns into a single row. How can I do that in the IDE?
Note: All the emails will be unique, so I don’t want them to be grouped. Could you please suggest how I can transpose these rows into columns and later merge them into one single row?
Thank you.
Regards,
Dhaval
Best answer by may_kwok
You should be able to use an aggregation step (e.g. Group Aggregator, or Representative Creator), and use the expression concatenate().
You can see my input of 5 lines, through the Group Aggregator to concatenate the column str together.
I use Group By 1, just to allow all records to be concatenated together, using comma as delimiter.
Does this help?
+4You should be able to use an aggregation step (e.g. Group Aggregator, or Representative Creator), and use the expression concatenate().
You can see my input of 5 lines, through the Group Aggregator to concatenate the column str together.
I use Group By 1, just to allow all records to be concatenated together, using comma as delimiter.
Does this help?
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
