Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Transpose data

  1. #1

    Default Transpose data

    Hello,
    I have an excel file that I have the information in this form:
    Name:  C1.PNG
Views: 171
Size:  1.4 KB
    I need to implement the online column that is like that,
    Name:  C2.PNG
Views: 173
Size:  1.5 KB
    I use the step "Row-normalize" but I did not get to have the good result

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

    Default

    What could possibly go wrong with Row-Normalizer after simply hitting "Get- fields"?
    Since you want to map all field values to the same "new field", there's not much to think about, too.
    Attached Images Attached Images  
    So long, and thanks for all the fish.

  3. #3

    Default transpose of source data

    Reviving two years old thread.

    If source data is :-

    Art A B C
    x 1215 1216 1852
    y 12 13 16

    Then it is not getting transposed in true sense (by following normalizer setup given in previous reply). Output from normalizer:-
    key value
    Art x
    A 1215
    B 1216
    C 1852
    Art y
    A 12
    B 13
    C 16

    Expected output is :-

    key value1 value2
    Art x y
    A 1215 12
    B 1216 13
    C 1852 16

    The idea is to create one column for every row (in source excel data) including header. Can anyone help me, here?

    Regards,
    Ritesh

  4. #4
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Because your expected output is re-denormalized.

    So.
    Remove the Art from the Normalize step.
    That gives you output like:

    typefield Art value
    A x 1215
    B x 1216
    C x 1852
    A y 12
    B y 13
    C y 16


    However, since you want to denormalize the data on typefield, you need to sort on that.

    Then you can feed it into a denormalizer step with Key of Art, Group of typefield, and Target fields of x and y.

  5. #5

    Default

    Hi - many thanks for your answer. It worked! I didn't realized that it is a case of normalizer and then denormalizer. Thanks for helping me out.

    Regards,
    Ritesh

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.