How to Transpose columns in a plan?

Question

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

may_kwok · Accepted Answer

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?

Cansu · Answer

Thanks for the solution @maykwok_hamilton🙌

Reply

Sign up

Login to the Ataccama Community

Scanning file for viruses.

This file cannot be downloaded