Im trying to join data from two different databases using a full join. I have created two different datasets, one for each database and also a third one to join these databases using full join with join clause as a field named reference from both databases. Im able to get some of the data in the analysis this way but many are missing. Is there anything im doing wrong here about joining two different datasets with a full join? Kindly help.
Could you share the data type of the reference field in both source datasets? Also do a distinct count on that field on both datasets.
Are you using direct query to build the two datasets? If so, could you use SPICE to store all the data?
Please also refer to the below documentation on dataset join:Joining data - Amazon QuickSight