I query my database to get a small table (7 rows, 2 columns), indicating if a process was successful or not.
In particular, if any of the rows has a zero in the second column, the process has failed.
I would like to branch: if no rows contain zero's send mail all went ok, if not, send one mail either containing the zero rows in some formatting or just send the table (ie the query result.)
I have tried using a tFilterRow, but then i send 1 mail for each row, and i just one email with the content of the mail depending on the query result.
Maybe you could use the filter and put the rows in a delimited file using a tFileOuputDelimited and enable the 'Don't generate empty file' option. And use on Subjob OK to trigger a tFileExists to check if a file was created. If there is a file you can use a tFileInputRaw to pick up the content and mail it. If there is no file there is no error.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.