Featured Post

Applying Email Validation to a JavaFX TextField Using Binding

This example uses the same controller as in a previous post but adds a use case to support email validation.  A Commons Validator object is ...

Monday, January 10, 2011

[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.



Posted by at

11 comments:

  1. Richard JacksonJuly 28, 2011 at 4:34 PM

    This is brilliant, thank you for sharing.

    ReplyDelete
  2. AnonymousMarch 29, 2013 at 11:16 AM

    That's great, thanks.
    How would you do this in reverse? i.e. Taking multiple rows in a flat-file, merging to one row with a list of values seperated by a comma in the cell of the final column?

    ReplyDelete
    Replies
    1. CarlMarch 30, 2013 at 9:45 PM

      Hi,

      Take a look at this post: http://bekwam.blogspot.com/2013/03/creating-multi-valued-attribute-in.html.

      Delete
  3. UnknownFebruary 3, 2016 at 3:43 PM

    Thanks for sharing this tutorial !.

    ReplyDelete
  4. UnknownSeptember 23, 2016 at 2:50 PM

    Interesting that I landed here, but my purpose is to apply this to different columns. E.g. I have an input file, it has 12 columns (one for each month) and it contains data for those months. I would like to normalize that to have instead 1 row with a "month" column & the associated data next to it.... Any similar module to tNormalize that acts upon multiple columns? Or do I need to build it up with tMap?

    ReplyDelete
    Replies
    1. CarlSeptember 23, 2016 at 2:52 PM

      You could just make one super-column out of your twelve and feed it through the components described in this post.

      Delete
  5. Tech NicheJuly 23, 2019 at 9:53 AM

    Tech Blog # Talend - Row to Column Transpose

    Hey Guys! We have come up with a detailed blog on Row to Column Transpose in Talend.

    Read it here - https://www.learningsutras.net/post/tech-blog-talend-transpose-rows-into-columns

    For more blogs on Talend - Join us for FREE or Subscribe to our site.www.learningsutras.net

    #talend #learningsutras #techblog

    ReplyDelete
  6. UnknownOctober 6, 2019 at 6:58 AM

    Thank you Carl!
    It's described very clear!

    ReplyDelete
  7. UnknownDecember 22, 2020 at 11:15 AM

    can we able to do normalize and denormalize using tmap

    ReplyDelete
  8. selimAugust 5, 2023 at 3:58 AM

    Legend Online Benzeri Oyunlar
    Mafia 2 Benzeri Oyunlar
    Simcity Benzeri Oyunlar
    Papers Please Benzeri Oyunlar
    Phasmophobia Benzeri Oyunlar
    V7C

    ReplyDelete
  9. NevzatAugust 17, 2023 at 11:47 PM

    salt likit
    salt likit
    dr mood likit
    big boss likit
    dl likit
    dark likit
    X8QJ

    ReplyDelete

Subscribe to: Post Comments (Atom)