Skip to Content
0
Former Member
Nov 17, 2011 at 03:41 PM

Compare one column value of a table with two column values in another table

770 Views

Hi all,

In Data Services can we compare one column value of a table with two column values of another table in profiling??

For ex : In table A sponsor description

In table B sponsor description, acronym.

In table A sponsor description column will have descriptions along with acronyms

Now I want to perform relationship analysis to find the non matching values in both columns of table B

I joined two tables on tableA.sponsor description= tableB sponsor description, acronym.

The result is 100% non matching values in both tables which is incorrect.

There are few common records in both the tables.

How do I get this???

Thanks