All Forums Database
sam141988 7 posts Joined 08/16
11 Aug 2016
Can we find out Column Level Mismatches between 2 Tables in Terdata?

I mean to Say when we do a MINUS on TD it returns the Entire Row where the Mismacth is Found. My Question is is there any possibilty where we can find the Column Where Mismatch has Occured and not the Full Row?
 
 

AtardecerR0j0 71 posts Joined 09/12
11 Aug 2016

To do that you should use full outer join way so you can join using key columns and compare the atribute columns one by one

Be More!!

sam141988 7 posts Joined 08/16
11 Aug 2016

Hi AtardecerR0j0,
Yes that way came to my mind too but the challenge here it will be when i am dealing with a table with more number of columns.
Isn't it?
Any other way can it be achived?
 

You must sign in to leave a comment.