Can you attach a sample workbook?
Try using a left outer join. Or depending on your dataset, try using full outer join.
For some datasets, Tableau can't support full outer join, in such a case you need a data manipulation tool such as Alteryx.
(It's more easy to answer when you append a workbook to your question)