topic Re: [resolved] Run If rownnum>1 in Talend Studio

[resolved] Run If rownnum>1

Anonymous — Thu, 08 Dec 2016 23:23:09 GMT

I need to add a conditional requirement to my job to end the job if no new records from a oracle component have been inserted into a record. If new records have been added then I want to finish the rest of the job (run a stored procedure). I think i can use 2 conditional run if components to accomplish this but I am running into issues with the syntax
i am going from a oracle_bulk component>>tjava>> run if true(tjava) or run if false(tjava) to try and accomplish this
i have the following code in the first java component which runs and returns true if the record count from the oracle component is greater than one. However when I add the true/false i can a sytanx error. What am I missing in the true and false tjava components?

int nb_line=((Integer)globalMap.get("tOracleOutputBulk_1_NB_LINE"));
if(nb_line>0){
globalMap.put("hasRows", true);
}else{
globalMap.put("hasRows", false);
}
System.out.println("hasRows: " + globalMap.get("hasRows"));

Re: [resolved] Run If rownnum>1

lvsiva — Fri, 09 Dec 2016 05:41:41 GMT

We can get the rows count with the variable "tMysqlInput_1_NB_LINE" and placed it in link condition like below.
((Integer)globalMap.get("tMysqlInput_1_NB_LINE")) > 1
You can use Oracle component instead of mysql.

Re: [resolved] Run If rownnum>1

Anonymous — Fri, 09 Dec 2016 16:19:59 GMT

Looks like the screenshots of my job did not upload. I am unclear what I need to update? Should I remove the first java component that I have with the if then else condition?

false condition

true condition

Re: [resolved] Run If rownnum>1

Anonymous — Fri, 09 Dec 2016 17:53:57 GMT

I figured it out. I was putting my condition in the java components instead of in the run if. Thanks all!