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 11, 2018 in Talend by misc.edu04
• 1,450 points
3,293 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.

Hope this helps!

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

Thanks.

answered Apr 11, 2018 by code.reaper12
• 3,500 points

edited Apr 11, 2018 by code.reaper12

Related Questions In Talend

0 votes
1 answer
+1 vote
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 11, 2018 in Talend by code.reaper12
• 3,500 points
1,000 views
0 votes
1 answer

Parsing JSON in Talend

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

answered Apr 3, 2018 in Talend by code.reaper12
• 3,500 points
2,476 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,500 points
975 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,500 points
5,770 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP