Compare DATA from 2 sources

[kakooo16]

I have data as such from table 1 :

--------------------------------------------------------------------------------------------------------------------------

PN | ART_FAB | MANUF_Name

--------------------------------------------------------------------------------------------------------------------------

AC2112223 |GRM1885C1H221K |MURATA

AC2112223 |

GCM1885C2A221JA16J

|

MURATA

AC2112223 |

GCM1885C2A221JA16D

|

MURATA

AC2112223 |

CC0603JRNPO0BN221

|

MURATA

AC2112223 |

C0603C221G5GAC

|

MURATA

AC2112223 |

C0603C221J5GAC

|

SAMSUNG

I have data as such from table 2 :

--------------------------------------------------------------------------------------------------------------------------

PN | ART_FAB | MANUF_Name

--------------------------------------------------------------------------------------------------------------------------

AC2112223 |GRM1885C1H221K |MURATA

AC2112223 |GCM1885C2A221JA16J |MURATA

AC2112223 |GCM1885C2A221JA16D |MURATA

AC2112223 |CC0603JRNPO0BN221 |AAA

AC2112223 |KBCGS |BBB

AC2112223 |898 |CC

How to compare data to get the data that is not the same in a reject table

I know that we can achieve this with output reject option in tMAP .

[MS5]

Hello,

You have 2 solutions to do that :

tMap : you do a join with all keys, selecting inner join as join model, and in output you set true to option "Catch lookup inner join reject" :

tJoin : if you use inner join option, you can have output reject "link" :

 

But in each solution, you have to define which table is the main table of your join : if it's table 1, you will have as output all line from table 1 that don't exist in table 2. If it's table 2, you will have as output all line from table 2 that don't exist in table 1. so if you want lines in table 1 and table 2 that are not in the other table, you will have to do 2 differents join / tmap