Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Values to columns: is it possible?

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Jul 2007
    Posts
    2,498

    Default Values to columns: is it possible?

    In order to use the chartcomponent the way I need it, I need to pass values to columns. Eg:

    date | driver | value
    _______________
    01-2007 | A | 12
    01-2007 | B | 11
    02-2007 | A | 13
    02-2007 | B | 16

    I would like this to become:

    date | value | A | B |
    _________________

    01-2007 | 12 | 11
    02-2007 | 13 | 16


    The closest thing I found was the row denormalizer, but it doesn't work quite this way. Of course, the "driver" column can have different values.
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  2. #2
    Join Date
    Dec 2005
    Posts
    531

    Default

    Hi,

    I found something else for you...never used it but it looks promissing:

    Resultset Crosstab Action

    Regards,
    Ingo

  3. #3
    Join Date
    Jul 2007
    Posts
    2,498

    Talking

    Once again, thanks a lot, Ingo.

    I didn't know that action, used it and worked as a charm!!

    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

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.