topic Empty table in Talend Studio

Empty table

Ven6 — Wed, 25 Mar 2020 14:04:30 GMT

Hi,I want to verify existing data on database

if data exist, sent mail sucess

if data does'nt exist sent de mail data don't exist

plz help

Re: Empty table

manodwhb — Wed, 25 Mar 2020 14:54:31 GMT

From table you get count and load as context variable and then you use run if trigger from tjavarow to trigger mail.

Tdbinput>>main>>tjavarow >>runif trigger tsendmail.

Re: Empty table

Ven6 — Wed, 25 Mar 2020 16:16:13 GMT

tDB --> tjava --->run if --> tsendMail

tjava create a variable context on an save nb of row