Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: Dynamic File Generation

  1. #1
    Join Date
    Aug 2011
    Posts
    15

    Default Dynamic File Generation

    Hi,

    I am creating dynamic file with "Text File Output", but am getting empty file whenever i run transformation.... empty File is created with field name and date-time stamp but data's are not created inside the file...

    For eg: If i have 4 lines of data, 3 files are created and 1 file is created as empty.

    am running out of time...
    Pls help me.......

    Thnks for your valuable replies

  2. #2
    Join Date
    Aug 2011
    Posts
    5

    Default

    Hi..can u please attach the errors you get while doing this..that will help to understand the problem..

  3. #3
    Join Date
    Aug 2011
    Posts
    15

    Default

    Quote Originally Posted by viditdesai View Post
    Hi..can u please attach the errors you get while doing this..that will help to understand the problem..

    ok.. i ll tel the scenario..
    i have 4 lines of data in table as follows:
    SerialNo Name
    01 AAA
    02 BBB
    03 CCC
    04 DDD

    am generating dynamic file with field name(Name)..
    I have to get four files, with data in it...


    I am getting four files, but with one file as empty
    AAA_DDMMYYYY.csv (correct)
    BBB_DDMMYYYY.csv (correct)
    CCC_DDMMYYYY.csv (correct)
    DDD_DDMMYYYY.csv (empty file)


    can you understand ?.. This is my question..
    Pls help me soon,, am
    running out of time........

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

    Default

    Do you have a FILTER step to assign data to each file?
    I would check the stream of data - all steps - from input to final output.

    It seems that for some reason, when you select rows to create the last file (DD) you are not finding any.

    Which steps do you use?

    Mick

  5. #5
    Join Date
    Aug 2011
    Posts
    15

    Default

    No i use "Text File Output" step to create dynamic file with the field name....
    I enable "Accept Filename From Field" option to create file dynamically...

    Its very simple, i use only "table input" and "Text File Output"...

    With Table input, i ll write query and fetch data's from DB table.
    With Text File Output, i need to generate dynamic file based on the "Field"...

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

    Default

    I guess my question was not clear.
    Do you create 4 files which contains teh same data?

    Could it be that the SQL query used for the last file does not pull any records?

    Mick

  7. #7
    Join Date
    Sep 2011
    Posts
    12

    Default

    Hi,
    what version are you using? I did the same test using the last version (4.2.0) and works fine.

    thanks
    Fábio Gibon

  8. #8
    Join Date
    Aug 2011
    Posts
    15

    Default

    Hi Mick,

    Files that are generating are not same , all are different data....

    No my query is nearly simple and it works fine while seeing preview...
    But, when i create dynamic file it is separated but i don't see any data's into it.


    As, i mentioned my scenario in previous post,
    they are four different files and data's are not same..

  9. #9
    Join Date
    Aug 2011
    Posts
    15

    Default

    hi , am using version 3.2.0

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.