February 1, 2019
i have table like here:
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