Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: [ASK] How Do Tranpose Data in Spoon

  1. #1
    Join Date
    Oct 2006
    Posts
    13

    Default [ASK] How Do Tranpose Data in Spoon

    How do we tranpose data in spoon?

    data example:

    FieldA|FieldB
    One|1
    Two|2
    Three|3
    Four|4
    ...
    ...

    into

    One|Two|Three|Four|....|....
    1|2|3|4|...|....

    the dot means the number is dynamic/vary.


    thanks
    Last edited by standalone; 08-21-2008 at 05:10 AM. Reason: change example layout

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    That may be pretty problematic... you can't have variable number of fields in PDI.

    So no, not really possible.

    If the number of rows is small you could do something to put all fields into 1 big superfield tagging information from each row when it passes by.

    Regards,
    Sven

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.