Trigger mail only if Attachment is not empty

[joe86]

Hi All,

I need to send a mail only when the attachment is having values. If the attachment is empty, i should skip sending mail. I checked advance setting of tSendMail and found no options to do so. one option that comes to my mind is to load the output to a table and take count of the table and do a workaround.

is there any other option in talend?? 

[manodwhb]

@joe86,first read the file size by using tFileproperties and load the file size column into global map and connect to tFilesiproperties to tsendmail by trigger run if then check the file size of global map value.

[joe86]

@manodwhb
can you please show me the flow??
tFilesiproperties -->tsetGlobalVariable-->tSendMail??
where should i give the "run if" trigger and where will i set the set the file size??

[manodwhb · Accepted solution]

tFilesiproperties -->tsetGlobalVariable--> tigger run if-->tSendMail

[joe86]

can you please confirm if below is correct?? any anything to be given inside the tSendMail component??

is the "key" and "value" been correctly declared??

[Anonymous]

@joe86

 Could you please show the content of your if clause? Click on that if condition and you can see the condition in the component tab.

 If you have not added, that's the place you need to add the details.

Warm Regards,

Nikhil Thampi

[manodwhb]

@joe86,that is correct you need to know that if you do not have the data in file what was the and if you have minimum data in a file what was the size and based on that you need to give the if condition in the run if.

[manodwhb]

@joe86,in the value of global ma you should specify the row2.size .

[joe86]

@nikhilthampi @manodwhb

i couldnt open the "if" condition.

when i click on the "if" line connected to tSendMail, i dont get option to give the condition.

below is what happens when i double click.

[Anonymous]

@joe86

Please check the below screenshot.

Warm Regards,

Nikhil Thampi