topic Re: Talend IF expression to compare tjava value in Talend Studio

Talend IF expression to compare tjava value

Anonymous — Sat, 16 Nov 2024 02:41:28 GMT

Hello,

My aims is to build a job that will do the following:

Check if count on table = 0
if true insert data

This what I have done so far.

Job Check Count

Step tMSSqlInput_1 : SELECT COUNT(*) AS CNT FROM TABLE

Step tJava_1 : context.var = row12.CNT; (Assign count value to variable)

Step tJava_2 : System.out.println(context.var); (Print variable var value)

Now I'm looking for an expression that will do a check if tJava_1 value = 0 then proceed to data insertion(Operations)

This is what I have added in the if conditions

((Integer)globalMap.get("tJava_2")).equals(0)

And its not working.

Can someone advice how I may proceed.

Re: Talend IF expression to compare tjava value

billimmer — Tue, 14 Apr 2020 15:26:11 GMT

in your if connection use:

context.var==0

Re: Talend IF expression to compare tjava value

Anonymous — Tue, 14 Apr 2020 15:45:05 GMT

Jobs fails
Exception in component tJava_2
java.lang.NullPointerException
at bi_rtm.alim_ods_0_1.ALIM_ODS.tJava_2Process(ALIM_ODS.java:1848)
at bi_rtm.alim_ods_0_1.ALIM_ODS.tMSSqlInput_1Process(ALIM_ODS.java:1777)
at bi_rtm.alim_ods_0_1.ALIM_ODS.tFileInputDelimited_11Process(ALIM_ODS.java:1453)
at bi_rtm.alim_ods_0_1.ALIM_ODS.runJobInTOS(ALIM_ODS.java:2916)
at bi_rtm.alim_ods_0_1.ALIM_ODS.main(ALIM_ODS.java:2718)

Re: Talend IF expression to compare tjava value

billimmer — Tue, 14 Apr 2020 16:35:43 GMT

then in tjava1 "row12.CNT " must be null. Right?

test this by replacing your tjava1 code with something simple like

context.var = 1;