Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: How to get mutiple output file from one file

  1. #1
    Join Date
    Apr 2013
    Posts
    26

    Default How to get mutiple output file from one file

    HI,

    i am using Data grid step in input step, to get Company_name(column header) and name(column header)
    Name:  company.png
Views: 54
Size:  6.9 KB

    so, i need multiple output file based on company name
    -----------------------------------------------
    for example:
    output:
    AAA_TCS.csv
    AAA_Wipro.csv
    AAA_CTS.csv
    .....
    ....
    .....
    so many files will be there based on company name
    (i need dynamic on company name)
    -----------------------------------------------------
    i used parameter name as ${company_name} in output file (AAA_${company_name.csv}) but it could not get output files

    Any idea! how to get?

    could you please provide me sample transformation?
    Please !!!!!
    thanks,
    Raju

    windows 7
    pdi 4.4
    Last edited by vsraju; 06-20-2013 at 03:41 AM.

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

    Default

    When you create a filename for each row derived from company_name, you can tell Text File Output to read that filename from a field.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Apr 2013
    Posts
    26

    Default

    Thanks marabu

    Can you give me example? how to do it?
    or
    could you please upload tranformations so, i can look it?

    Thanks in avdance

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

    Default

    In the Text output file, there's a check box in the advanced options (or options).
    As long as you have a filename (or Path+filename) column in your original file which has the correct value for each record, it's a job done.

    You can find samples for almost every step into your installation folder /samples.

    Mick

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.