Sir, I did go through it and I have added the links that were missing but still, I getting the same thing.
I am considering flipping over the data sources and making Primary to Secondary and vice-versa.
Do you have any other approach to this?
I have one more question, do we have to link all the possible fields or just the ones which is useful for us in the view?
Selective linking is a strategy folks use to get the data into a usable shape. So the answer is no, you don't have to link all relevant fields. You can link on all or just one relevant field. But test, test, test....
PS: Yesterday I mentioned to a client that a Tableau 'blend' is actually a modified/limited Left Join. A light went on in his head, and many of his questions were self-answered. I mention this just in case this helps.
Thanks for the advice.