Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: One input to multiples outputs

  1. #1
    Join Date
    Aug 2017
    Posts
    8

    Default One input to multiples outputs

    Hey everybody,

    So I'm having a challenge to figure out what's the best way to get one .CSV (input) and have multiple outputs based on a specific parameter. For example, let's say I have a system that register all sales transactions from my company. Something like this:

    SALESMAN TRANSACTION TYPE DATE AMOUT
    David New Contract
    2/3/15
    $5,000.00
    David Recurring Fee
    2/5/15
    $3,400.00
    Abner New Contract
    2/8/15
    $2,000.00
    David End of Contract
    2/12/15
    -$3,500.00
    Mary Recurring Fee
    2/15/15
    $7,000.00
    Abner Recurring Fee
    2/18/15
    $2,100.00
    Mary New Contract
    2/22/15
    $13,000.00
    Mary Recurring Fee
    2/25/15
    $2,200.00


    My question is, how can I have an output where I would get one file just for David, another for Abner and a third file for Mary with their own individual transactions?

    Please, have in mind that the system has over 200 hundreds Salesman.

    Thanks!!!!

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    In the samples folder (in your data-integration directory) are sample with that problem. Have a look at "Process all tables.kjb"
    So create a list with all individual salespersons and execute another job for each individual salesperson

  3. #3
    Join Date
    Apr 2008
    Posts
    4,690

    Default

    Or even more simply:
    Create a filename column (David.csv, Abner.csv, Mary.csv) based on existing data in the columns and some constants.
    Then use the "Filename in field" option of the text file output to redirect the rows to the correct files.

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.