Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: PDI Normalize row scenario

  1. #1
    Join Date
    Nov 2007
    Posts
    5

    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
    Posts
    5,534

    Default

    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.