Run If Number of rows in the input file are greater than 1

[Anonymous]

Hello,

I am trying to create a job, where I read a csv input file, and if the number of rows>1, it should run and pick the file and place into FTP location.

I have used tfileinputdelimited-->tjavarow-->tftpPut

I am stuck at tjavarow. How do I write a condition where it checks for number of rows >1. Please see the job 

[iamabhishek · Accepted solution]

You don't need tJavarow for this.

Connect tfileinputdelimited-->runif trigger-->tftpPut.

And put the condition for runIf as -

((Integer)globalMap.get("tFileInputDelimited_1_NB_LINE")) > 1

[iamabhishek]

I am guessing you have the runif trigger already established between your two components - meaning you have both of them connected. Now, right click on the runIf connector - click settings - and you would be presented with Basic Settings -> Condition. Have your condition at that section.

[iamabhishek]

I had suggested to use the "Run If" trigger and not "On Component Ok".

[Anonymous]

Thank you so much.. !!!