I am trying to extract the data from two sources i.e. Oracle and Excel. Now i intend to extract the records where the data does not match on joining at the common field.
We can extract the data where the record match on the common field using relationships, but what if we need to extract where the records dont match then how to get that.
Pls help me on this.
Thanks in advance
It sounds like what you want is be able to blend two data sources but to show data that doesn't belong to both in the blended field. Tableau will only show all the dimensions of the primary source of the blended field. Is it possible to add the Excel data to Oracle?