Comparison of data from 2 tables

Five Stars

Comparison of data from 2 tables

Hello,

 

Need help please. How to compare data from 2 identical tables but in 2 different servers?

Thanks for help.

 


Accepted Solutions
Five Stars

Re: Comparison of data from 2 tables

Hello. Here is the methos I used. Thanks for your help.

Capture.PNGCapture.PNG

View solution in original post


All Replies
Forteen Stars

Re: Comparison of data from 2 tables

@Kaliana ,you can do in may ways and the one way is you can do using tmap below way.

https://community.talend.com/t5/Design-and-Development/How-to-compare-rows-between-two-tables/td-p/1...

 

if you have access to data quality you can try the below way.

https://help.talend.com/reader/SYA~BWHwsO0vEuiaWAEpTA/S6QBejHCyak6a6H9bWWePA

 

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: Comparison of data from 2 tables

@Kaliana , If this issue resolved ,please mark the solution so that it would be useful to others. 

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Five Stars

Re: Comparison of data from 2 tables

Hello. Here is the methos I used. Thanks for your help.

Capture.PNGCapture.PNG

View solution in original post

Twelve Stars

Re: Comparison of data from 2 tables

hi,

just to say that you are comparing only on one way.

you do no detect line only on table 2...

in this case I'm use to make an union of the 2 table then having a lookup of each distinct line in each table source (table 1 and 2).

with that method you can have a full comparaison.

good luck

Francois Denis

Tag as "solved" for others! Kudos to thanks!

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog