Converting Columns into Rows in Talend

0 votes

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!

Apr 10, 2018 in Talend by misc.edu04
• 1,420 points
794 views

1 answer to this question.

0 votes

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:image

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:

image

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

answered Apr 10, 2018 by code.reaper12
• 3,450 points

edited Apr 10, 2018 by code.reaper12

Related Questions In Talend

0 votes
1 answer
0 votes
1 answer
0 votes
2 answers
0 votes
1 answer

Looping through all the schemas in Talend

It is really simple to make tOracleInput ...READ MORE

answered Apr 10, 2018 in Talend by code.reaper12
• 3,450 points
126 views
0 votes
1 answer

Parsing JSON in Talend

While working with JSON files, one thing ...READ MORE

answered Apr 2, 2018 in Talend by code.reaper12
• 3,450 points
556 views
0 votes
1 answer
0 votes
1 answer

Specifying the number of Rows Processed in Talend

Hi, you can try using tSampleRow component ...READ MORE

answered Apr 14, 2018 in Talend by code.reaper12
• 3,450 points
104 views
0 votes
1 answer

How to generate multiple rows from a single row in Talend?

I think using tJavaFlex, tMap and tFlowToIterate ...READ MORE

answered Apr 18, 2018 in Talend by code.reaper12
• 3,450 points
1,463 views