Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Dont know how to do the following:

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Dont know how to do the following:

    Hi,
    I am not sure how i can archieve the following, if at all possible i want to transform table1 to table2. Is this possible?

    Table1:
    id measuretype value

    1 5 somevalue1
    2 7 somevalue2

    Table2:

    id measuretype5 measuretype7
    1 somevalue1 somevalue2

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Dont know how to do the following:

    Sure, this is possible except for the ID, I don't think this is correct.

    Shouldn't the input be like this?

    id measuretype value
    1 5 somevalue1
    1 7 somevalue2

    In that case, you can use the "Row Denormaliser" step to do this.
    The key-value pair is measuretype-value

    Specify the id in group, the target field and the key to look for.

    Hope this helps,

    Matt

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.