Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Regarding Looping Job Issue: setting of variables for Looping

  1. #1
    Join Date
    Jun 2011
    Posts
    20

    Exclamation Regarding Looping Job Issue: setting of variables for Looping

    In the Looping Job which contains two transformations:

    1. Obtaining values from flat file and assigning these to the variable
    2. Using the variable to insert data into the Production Table.

    The first Transformation throws up an error when the flat file contains more than one value in it.

    Finally, I intend to run my job depending on the number of values contained in the flat file.

    Do let me know at the earliest if there is a workaround.

    Thanks and Regards,
    Siva
    Last edited by siva; 11-14-2013 at 07:47 AM.
    siva.

  2. #2

    Default

    Would it not be easier to use the 'execute for each row' property of the job entry detail for the transformation that needs to loop?

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.