Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Lookup multiple values, convert to columns

  1. #1
    Join Date
    Jun 2013
    Posts
    24

    Question Lookup multiple values, convert to columns

    Fairly new to Kettle, I am a bit stumped.

    I have a transformation that lists "sessions", and for each session there is supposed to be a variable number of "presentations" listed in a column. Sessions are in one database table, presentations are listed in another database table, using SessionID as a join. So, for example, we would have:

    Session 1, Presentation 1, Presentation 2, Presentation 3
    Session 2, Presentation 1, Presentation 2
    Session 3, Presentation 1, Presentation 2, Presentation 3, Presentation 4, ..., Presentation 73.

    How to do this?

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

    Default

    Without going into much detail: You can use a Group By step (category Statistics) to aggregate all the presentations from a session into a comma separated string.
    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.