Emailing results in an Excel Sheet

Highlighted
Six Stars

Emailing results in an Excel Sheet

Hello All,

I have two tables TABLE 1 and TABLE 2. Both tables are in oracle database.

1.PNG

I need to join these two tables and left outer join on TABLE 1 and the difference of records need to be sent as an attachment in an Excel sheet in an email.

In this case below two records must be sent in an Excel sheet with headers.

 

2.PNG

This email should be sent if there is only difference of records in these two tables. If there is no difference of records in these tables then there is no need to send an email.

Please let me know how to achieve this. Please let me now the job flow.

The designed job is scheduled every day.

Thank You.


Accepted Solutions
Fifteen Stars TRF
Fifteen Stars

Re: Emailing results in an Excel Sheet

Use inner join instead and select the "catch inner join reject" option on output flow.
Connect tMap to tFiilOutpiuExcel component and select the "don't generate empty file" on.
Start next subjob with tFileExist connected to tSendMail with an "if" trigger and use tFileExist_1_EXIST as the condition. Define tSendMail properties and add the attachment.

TRF

All Replies
Fifteen Stars TRF
Fifteen Stars

Re: Emailing results in an Excel Sheet

Use inner join instead and select the "catch inner join reject" option on output flow.
Connect tMap to tFiilOutpiuExcel component and select the "don't generate empty file" on.
Start next subjob with tFileExist connected to tSendMail with an "if" trigger and use tFileExist_1_EXIST as the condition. Define tSendMail properties and add the attachment.

TRF
Six Stars

Re: Emailing results in an Excel Sheet

Thank You TRF. I was able to create the job successfully.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Talend Cloud Developer Series – Defining Metadata

This video focuses on different methods of adding metadata to a job in Talend Cloud

Watch Now