Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Split rows into different streams based on grouping attribute

  1. #1

    Default Split rows into different streams based on grouping attribute

    Hello,
    I have different employees and their department ID's. I have sorted them based on their department ID's and now I want to split the employees with same department ID's into different streams. Can anyone suggest me how to achieve that?

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

    Default

    Switch/Case is the name of a step that could be helpful.
    So long, and thanks for all the fish.

  3. #3

    Default

    Yeah, 'Switch case' is feasible if I know the department ID's in advance. But if there are large number of department ID's say 40-50, using that step becomes slightly cumbersome because I have to specify of the values of 40-50 Department ID's in the case step. Is there any way like 'split the stream based on grouping attribute' without specifying the values of grouping attribute?

  4. #4
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Not on top of my head, but you can create multiple files based on a field content.
    -- Mick --

Tags for this Thread

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.