Forum

Comparing each fiel...
 
Notifications
Clear all

Comparing each field from 2 tables

2 Posts
2 Users
0 Reactions
142 Views
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

Hello Guys,

i have table like here:

Screenshot_153.png

And comparing with the same structure table based on Composite Key (Key1 and Key2). 

What i have to check is if every other column (not key) is different then its equivalent in second table,
I can use just If custom column but imagine that i have 20 or more columns and about 50 tables to do this. 
After knowing that column value from specific row is different i am filtering row and getting result. 

In our example we are getting Key1 Key1 as result because only for this key in Col2 there is a different string (not equal to second table). 
Maybe there is possibility to add some custom function to achevie this? Or loop? 

Like check all columns and its equivalents if they are equal. 
So If Col1 = Table2.Col1 = 1 else 0

Best,
Jacek

 
Posted : 13/04/2021 5:47 am
(@catalinb)
Posts: 1937
Member Admin
 

Possible solution attached.

 
Posted : 17/04/2021 3:23 pm
Share: