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,380 points
391 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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

Adding third party libraries into the Talend project

You can add the 3rd party libraries ...READ MORE

answered Apr 9, 2018 in Talend by code.reaper12
• 3,450 points
200 views
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
48 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
333 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
45 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
697 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.