You have to take at least one dimension from the primary database and plug it into the view (hide it if its not important but still need to plug one in) - once you do this then you can bring in the sets and should be able to see ID's from both databases.
Sorry but it still does not working .
In fact, I have just seen that, even when I put only the dimension of ID of the secondary data base, it shows only those which are also in the primary data base so maybe it comes from here. Could you help me please ?
Thank you very much in advance.
When you blend two data sets, you are creating LEFT OUTER JOIN operation on them. You cannot get FULL OUTER JOIN with blending, however, if there is a data source that has all ID's, make it primary and should work.
If neither data sets has full ID's, you can create a custom SQL to create a UNION of ID's between these two data sets and make it as a primary. Hope this helps and if you need more help, please attach your sample data and I can take a look at it.
Check this article on blending tips;
Thank you very much ! ☺
De : Karunaker Molugu
Envoyé : lundi 20 octobre 2014 16:00
À : Florence Lefevre
Objet : Re: - Hello ! Data blending and combined sets
Tableau Support Community <http://community.tableau.com/?et=watches.email.thread>
Hello ! Data blending and combined sets
reply from Karunaker Molugu<http://community.tableau.com/people/karunaker.molugu?et=watches.email.thread> in Forums - View the full discussion<http://community.tableau.com/message/304650?et=watches.email.thread#304650>