Forum Discussion

sanjeevkumar7's avatar
sanjeevkumar7
Occasional Contributor
15 years ago

Datasource loop groovy

Hi - I have a "datasource" and "datasource loop" step and all other steps in between those two. My datasource contains multiple rows.

Is there a way to find when I'm looping through the 1st row and the last row. I have to process something during the 1st row ( run_id which increments only once during a run) and run a stored procedure at the end of the run (runs after it completes processing all the rows in the datasource)

Appreciate your time..

Thanks!
Sanjeev

1 Reply

  • Hi!

    Create a Number DataGen starting at 1 just below your DataSource and check if the number is 1.

    You can find out if a DataSource is at it's last row, but why not just put the Stored Procedure after the DataSource Loop step?


    Regards!

    /Henrik