[resolved] Run if Trigger condition for e-mail

[_AnonymousUser]

Hello,
In the below attached ETL screenshot, I want to send an e-mail to personnel when there is a record/ multiple records in rejected table.
In the trigger I have specified the condition as
(globalMap.get("tAS400Output_2_NB_LINE")) != null.
When I run the ETL e-mail is being sent even when there are 0 records in rejected table.
Please advice.

[Anonymous]

Hi anut7,
I don't see any attached ETL screenshot, could you check it?
Best regards
Sabrina

[Anonymous · Accepted solution]

Hi
The global variable ((Integer)globalMap.get("tAS400Output_1_NB_LINE")) returns an int value, the expression can be (for example):
((Integer)globalMap.get("tAS400Output_1_NB_LINE"))==0
Shong

[_AnonymousUser]

Thanks Shong. It worked.