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