topic Re: run if in Talend Studio

run if

Anonymous — Fri, 23 Nov 2018 19:41:10 GMT

hi,

i have this job and i have this result

and i want to send mail if he see "A" in the last column, but here he just takes the last line in the last column ( it's "B") and the answerof the run if is "B".

Thanks for your answer

Re: run if

Anonymous — Fri, 23 Nov 2018 23:54:57 GMT

Use a tFlowToIterate after the tLogRow. Then connect that to a tJava using an iterate link. After the tJava, use your RunIf. The RunIf logic should be based on a globalMap value. This is because the tFlowToIterate component will convert your data row to globalMap values. The key to each column will be the row name feeding into the globalMap and the column name. So, if your column is a String and is called "MyValue" and your row is called "row3", your globalMap value will be accessed like below....

((String)globalMap.get("row3.MyValue"))

Your previous method did not work as the RunIf fires after the component has finished. By adding the tFlowToIterate, it means the subsequent components both start and end with each iteration. This means your RunIf will be tested for every row.

Re: run if

Anonymous — Sat, 24 Nov 2018 07:45:56 GMT

@rhall we use that in tJava?

((String)globalMap.get("row3.MyValue"))

Re: run if

Anonymous — Sun, 25 Nov 2018 13:29:59 GMT

No, the tJava should be left empty. The globalMap code I gave you simply shows you how to access the column value for your RunIf logic.