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.


Re: About master check


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


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.






Cloud Free Trial

Try Talend Cloud free for 30 days.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.