topic Re: how to use global variable in runif condition in Talend Studio

how to use global variable in runif condition

Anonymous — Sat, 16 Nov 2024 02:56:12 GMT

Hello!

I have a challenge

I have a task to check the count of Mysqlinput query is 2. If the count is 2 then only trigger the email, otherwise no need to trigger email.

Please find the screenshot of my job flow below:

I used to tjavarow to capture the out from tmap and store it in global varibale, see below:

How to check the global variable value for 2 in runif condition.

Please help me anyone as I am new to Talend.

TRF — Thu, 19 Mar 2020 15:37:06 GMT

Here is the expression for the "If" trigger:

((Integer)globalMap.get("tDBInput_1_NB_LINE")) == 2

If you want to print the value:

System.out.println("Value is " + ((Integer)globalMap.get("tDBInput_1_NB_LINE")));

Anonymous — Thu, 19 Mar 2020 17:42:28 GMT

I used the below line in runif and it worked:

!globalMap.get("globalvar").equals(2)

TRF — Thu, 19 Mar 2020 18:29:56 GMT

Did you try for an input table with just 2 lines?