Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Deflattener ...

  1. #1
    Join Date
    May 2007
    Posts
    2

    Question Deflattener ...

    Hello,

    It have a transformation call the Row Flattener. I'm searching a technique to DeFlattener.

    Example:

    I have rows like that:

    KEY FIELD_1 FIELD_2
    -------------------------------------
    1 aaa bbb
    2 bbb ccc

    And I want to deflattenered as that:

    KEY FIELD_1_plus_2
    -------------------------------
    1 aaa
    1 bbb
    2 bbb
    2 ccc

    I can do it with a SQL statment but do it have a way to do it with Kettle?

    Thank you

    sauros
    Last edited by sauros; 05-15-2007 at 03:08 PM.

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Obviously. You can do this with the Row Normaliser.

  3. #3
    Join Date
    May 2007
    Posts
    2

    Default Yep!

    Yes You are right!

    I just forgot my class course

    Thanks

    sauros

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.