Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Data from column cells

  1. #1

    Default Data from column cells

    Hi all,

    I trying to get the follow result. What i have is:

    column1 column2 column3
    X A S
    X B S
    X C S
    Y A L
    Y B L
    Z B S

    what i want is:

    column1 column2 column3
    X A,B,C S
    Y A,C L
    Z B S

    how can i do this with PDI
    thank you

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

    Default

    Have a look at the Group By step
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  3. #3

    Default

    Quote Originally Posted by gutlez View Post
    Have a look at the Group By step
    Hi gutlez,
    Thank you, its working good.

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.