Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: PDI Normalize row scenario

  1. #1
    Join Date
    Nov 2007

    Default PDI Normalize row scenario

    I have the following data set as an output form a table query

    Codes Value
    10010 TestName1
    10020 Type1
    10030 Value1
    10110 TestName2
    10120 Type2
    10130 Value2

    In the code first 3 characters mean identify a row to normalize to and the last 2 characters the values. The outcome of these 6 rows will become 2 in the form

    Code Name Type Value
    100 TestName1 Type1 Value1
    101 TestName2 Type2 Value2

    How can this be completed using standard Pentaho PDI steps?

    Thanks for any help.

  2. #2
    Join Date
    Jun 2012


    We use Row Denormaliser to turn key/value into row/field format.

    Name:  Cut.png
Views: 22
Size:  22.7 KB

    Name:  Denorm.png
Views: 24
Size:  29.2 KB
    So long, and thanks for all the fish.

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.