topic Re: Sending conditional mail in Talend Studio

Sending conditional mail

Anonymous — Wed, 26 Apr 2017 13:43:03 GMT

Dear's, I am using a talend job to send a mail if ACTIVE_FLAG=1 then send mail else dont send it .

here is my job design

Now after tlogrows , i will need to add a tsendmail component , and i want to write a IF condition , IF ACTIVE_FLAG =1 thene send mail else dont send mail .

Can you help with this design , with proper and correct syntax please.

Many Thanks.

Amit

Re: Sending conditional mail

TRF — Wed, 26 Apr 2017 13:52:19 GMT

Is active_Flag a context variable?

I suppose the answer is yes and the variable is defined as a boolean.

After tLogRows, add a tSendMail component and use an "if" link between them (right click tLogRows and select Trigger > Run if).

Click the link and enter the condition:

context.active_Flag == true

Hope this helps,

Re: Sending conditional mail

Anonymous — Wed, 26 Apr 2017 14:03:27 GMT

No ACTIVE_FLAG is a column name , and if that column name has value 1 Then we have to trigger email component

Thanks..

Re: Sending conditional mail

TRF — Wed, 26 Apr 2017 14:14:53 GMT

Add a tFilterRows after the tLogRows to keep only the desired rows and connect tSendMail after tFilterRows.

Here is the tFilterRows configuration:

Re: Sending conditional mail

Anonymous — Wed, 26 Apr 2017 14:19:06 GMT

Dear,

After Tflterrow , i will connect tfilterrow to tsendmail right ?

what trigger i should use to connect to tsend mail ?

onsubjob ok?

Many Thanks.

Re: Sending conditional mail

TRF — Wed, 26 Apr 2017 14:29:33 GMT

Use the "Filter" flow to connect tFilterRows with tSendMail.

Here is the job picture:

Regards,