About master check

Five Stars

About master check

Please let me know, master file check.

 

The employee master is placed in a predetermined folder with an Excel file, and when reading data before conversion.
I want to check the master and output the corresponding record to another file
Can you teach us how to realize it?
Currently, I'm connecting the input file to tMap and connecting employee master with Reject but as you think
It is a situation not output.

Moderator

Re: About master check

Hi,

If we understand your requirement very well, you can compare multiple files and get the difference.

The work flow should be:

input1-->tMap(join your input source and set "catch lookup inner join reject." as true)-->output1

input2-->(lookup)                                                                                                        -->output2(catch inner join reject)

Let us know if it what you are looking for.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: About master check

Thank you for your quick response.

 

For example, the item of the journal file has the ID of the employee who has voted.
Before registering in the accounting system, exclude records that do not exist in the employee master compared to the employee master in a separate file.

 

According to your answer, I tried assembling as shown in the figure.

Would you please let me know if there are points that are wrong.

 

Thank you.

 

Yoshi_h

 

Flow.pngtMap.png

 

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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now