Converting Columns into Rows in Talend

Question

I am new to Talend and am trying to learn how to transform 3 columns of a row into 3 separate rows. Below is a sample of my matrix:

C1           C2           C3

 X              Y             Z

It should transform into:

Col

X

Y

Z

Please help!

Answer 1

Hi,

You can try using tNormalize component along with tMap component. It worked for me. Below is the screenshot of my Job and the expressions I used for the transformation of the columns.

To perform this, add and link the components as shown below:

Once you are done setting up the components, go to the tMap component and concatenate your rows and columns with a semi-colon (;), as shown below:

Finally, normalize the data, to get the desired input.

Hope this helps!

To know more about Talend, join Talend for big data certification training today.

Thanks.