How to know the conformity of the Data between two Tables A, B ?

[kakooo16]

Hello ,

So , i have two tables A(id , name , Age ) and B (id, name , Age) .

My question is how could i know if the data in A is the same in B .

1- If the date is the same (it s great) thats the purpose of my job .

2- If no , i would like to modify the data to get the same values in A,B

My idea was to do an inner join between all the fiels (like the file below )

Is there any recommendations ?

Thanks in advance .

[Jesperrekuh]

With an id in both sets, I would assume you're looking to find duplicates within based on name and age?

Remove the id in the match. First Neutralize name by removing spaces, strange chars, and everything in lower or upper to maximize matching.

name.replaceAll( "[^A-Z]","")

[kakooo16]

Where do i have to put the name.replaceAll( "[^A-Z]","")

Thanks

[root]

Another approach is to do it at a SQL level.. if your DMBS supports "Except", you can run that and see the number of rows returned. Thanks

[Jesperrekuh]

tReplace-component (advanced mode, regexp pattern) before using the tMap.