Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Get File Rows Count Problem

  1. #1

    Default Get File Rows Count Problem

    Hi,

    I'm creating a simple text file output (using select values) and simply need to count the number of rows in this output file, for which i'm using Get File Rows Count step by supplying it the location and name of the output file.
    The error i get is as follows -

    " No file(s) specified. Stop processing! "
    All steps run in parallel , and Get rows count step is executing before the output text file is created.

    Is there any way to read the number of rows of of this text output file being created in a tranformation and use the count in the same tranformation??

    I've attached the .ktr here.
    TEST.ktr

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

    Default

    You don't have to read the text file you just wrote, only to find out the number of lines in it.
    Have a look at the Statistics step "Output steps metrics".
    Just add it to your transformation and provide the name of your TFO step - input is hopless
    Last edited by marabu; 08-29-2012 at 05:22 AM. Reason: added how-to
    So long, and thanks for all the fish.

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.