Skip to main content

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?

 

Original Data
 
After Transpose

 

Final Output

 

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

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?

Thanks for the solution @maykwok_hamilton 🙌

Reply


Community Terms of Use & ConditionsCookie settings