Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Problem with execute for every input row

  1. #1
    Join Date
    Aug 2011
    Posts
    3

    Default Problem with execute for every input row

    I'm working on a job that is set up like this.

    Start -> Trans A -> Job A

    Trans A (Advanced execute for every input row)
    CSV File input (input from csv file with sftp setting. ie, uname, pass, directory, etc...)
    Set variables (set all the variables from the csv file)

    CSV File -> Set Variables

    Job A
    Start -> Get a File with SFTP

    now in my csv file, i have 2 lines

    server, port, username, password, remote_dir, local_dir
    192.168.1.1, 22, ftpuser, ftppass, /, /ftp/

    With one line in the csv file, seems to work. But if I a2 2 additional lines, I get this error.

    server, port, username, password, remote_dir, local_dir
    192.168.1.1, 22, ftpuser, ftppass, /, /ftp/
    192.168.1.2, 22, ftpuser, ftppass, /, /ftp1/
    192.168.1.3, 22, ftpuser, ftppass, /, /ftp2/


    Only 1 input row was expected to set the variables and at least 2 were received.

    I check the execute for every input row in trans a and ran , error
    I check execute for every input row in trans a and job a, ran, only processed one line
    I check execute for every input row in job a ran, only processed one line.

    Any assistance would be appreciated.

  2. #2

    Default

    You should be reading the CSV file in TransA and then the end of the data stream should be a "Copy rows to result" step. This copies the rows to the result stream for job entries.

    Text File Input ->- Copy rows to Result

    On Job A setting, check Advanced > Execute for every input row. Inside Job A you problem want a transformation, which has as its first step "Get rows from previous result", where you specify the name and type of the rows you passed in Trans A.


    Does this help?

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.