topic Re: Compare values returned by subjobs and execute another. in Talend Studio

Compare values returned by subjobs and execute another.

jcpreaux — Fri, 23 Mar 2018 16:33:31 GMT

Hi,

I've 2 subjobs (Subjob #1 & #2) whom return values (put in the globalmap) and i want to execute another subjob (Subjob #3) if these values are equals.

I'v tried with the "if" trigger but the third subjob is always played even if values aren't equals.

----

# Subjob #1 : Sales query
tMysqlInput_1 ----- tMap_1 ------ tFileOutputDelimited_1 (myFile.csv)
                       |
                       |
                       |
                   tAggregateRow_1 ----- tJava_1 (globalMap.put("CA_Ventes",row4.SUM)

# Subjob #2 : Statistics query
tMysqlInput_2 ----- tJava_2 (globalMap.put("CA_Stats",row5.SUM_MONTANT_LIVRE_)

# Subjob #3 : (globalMap.get("CA_Stats") == globalMap.get("CA_Ventes"))? put FTP : Die and call

------

Any idea ?

PS : i use TOS for Data integration v6.5.1.

Thanks.

JCP

Re: Compare values returned by subjobs and execute another.

vboppudi — Fri, 23 Mar 2018 16:59:55 GMT

Hi,

What are you trying to do in subjob3?

Regards,

Re: Compare values returned by subjobs and execute another.

jcpreaux — Fri, 23 Mar 2018 17:02:42 GMT

Hi,

The subjob #3 puts the file generated by subjob#1on an FTP server.

JCP.

Re: Compare values returned by subjobs and execute another.

Anonymous — Fri, 23 Mar 2018 17:08:32 GMT

The looks like it should be OK. Can you post a screenshot please and also show the RunIf condition? It might also be interesting to see how you set the globalMap values.

Re: Compare values returned by subjobs and execute another.

jcpreaux — Fri, 23 Mar 2018 17:25:59 GMT

The job :

The second id condition : globalMap.get("CA_Stats") != globalMap.get("CA_Ventes")

The subjob #3 isn't yet designed but i tried with Sendmail and Die components.

Components tJava_2 and tJava_3 put values in the globalmap :

#2 :

globalMap.put("CA_Ventes",row2.SUM);

#3 :

globalMap.put("CA_Stats",row3.SUM_MONTANT_LIVRE_);

Thanks,

JCP

Re: Compare values returned by subjobs and execute another.

vboppudi — Fri, 23 Mar 2018 17:41:50 GMT

can you please check globalMap assignment working properly ?

Display global value before using in condition.

I tried the same and it's working.

Regards,

Re: Compare values returned by subjobs and execute another.

jcpreaux — Fri, 23 Mar 2018 18:31:16 GMT

I've modified the job because globalmap variables were'nt well assigned.

The component tJava_4 print the variables as shown above in the execution tab.

Variables are equals but the "not" condition is always played.

Re: Compare values returned by subjobs and execute another.

vboppudi — Fri, 23 Mar 2018 18:34:01 GMT

so issue resolved ? if yes please mark it as solved.

Regards,

Re: Compare values returned by subjobs and execute another.

jcpreaux — Mon, 26 Mar 2018 08:21:15 GMT

Hi,

The problem came from the way i compared my values in the if trigger.

I replace :

globalMap.get("CA_Stats") == globalMap.get("CA_Ventes")

By :

((BigDecimal)globalMap.get("CA_Stats")).compareTo(((BigDecimal)globalMap.get("CA_Ventes"))) == 0

And it works fine.

Thanks !

JCP