Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Transpose rows to columns

  1. #1
    Join Date
    Mar 2007
    Posts
    5

    Default Transpose rows to columns

    Hi,

    Is there a way to transpose rows to columns using spoon steps.

    Source data and desired target data should be as shown in the attachment.


    Tried row de-normalizer but couldn't get the desired output. Would appreciate any help.

    Thanks
    Kumar
    Attached Files Attached Files
    Last edited by karumugam; 03-13-2007 at 03:54 PM.

  2. #2

    Default

    I think this can be done by row denormaliser. Sorry but your example is unreadable. Can you please edit or repost it?

  3. #3
    DEinspanjer Guest

    Default

    Could you try reformatting your example? I can't make sense of it as is.

  4. #4

    Default

    Hi,

    Here is my denormalization transformation, used to transpose rows (CODE_INDICATEUR_JOUR) to columns (from CA_BAR to TOTAL_HEURES) according to a key value.
    Simple and works great.
    Attached Images Attached Images  
    Vincent Teyssier
    BI Architect
    http://open-bi.blogspot.com
    06.89.77.50.37

  5. #5
    Join Date
    Mar 2007
    Posts
    5

    Default

    Thank you Vincent. Tried the row de-normalizer again but i couldn't figure out the way to get the desired output as per the attached Excel sheet. Thank you for your
    time.

    Have a good one.

    Kumar
    Attached Files Attached Files

  6. #6
    Join Date
    Mar 2007
    Posts
    5

    Default

    Sorry that my example was not readable. Could you please check out the attachment on this thread.

    Thank you

  7. #7
    Join Date
    Jul 2017
    Posts
    1

    Default

    hey, did it got resolved?

  8. #8
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    You are trying to revive a thread that died 10 years ago.

    Good luck.
    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.