Author Topic: [TUTORIAL] Turning a Column into Rows with Talend Open Studio  (Read 67 times)

0 Members and 1 Guest are viewing this topic.

Offline Corps

  • Sr. Member
  • *
  • Posts: 282
  • Karma: +0/-0
    • View Profile
[TUTORIAL] Turning a Column into Rows with Talend Open Studio

Use the tNormalize column to break a multi-valued attribute stored in an RDMBS column into individual rows.  This is great for a second pass on an input file to fill up a join.
This tutorial shows how to take a record containing a multi-valued attribute (like "SWI,CON,TEN") and write out a record for each value (a record for "SWI", a record for "CON", a record for "TEN").

Talend Open Studio has a great component for this called tNormalize.


Techronnati | where technology never sleeps


Mountain View

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
92 Views
Last post August 08, 2014, 07:46:33 AM
by rpmolecule
2 Replies
164 Views
Last post April 27, 2017, 09:34:46 AM
by JusticeLeague
2 Replies
111 Views
Last post August 11, 2016, 01:12:44 AM
by MrSpecialist
0 Replies
71 Views
Last post February 26, 2016, 01:52:11 AM
by Corps
0 Replies
84 Views
Last post December 14, 2016, 10:15:08 AM
by MrSpecialist

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.