-
1. Re: See all the customers in the DB even does who haven't values (Data Blending)
Russell Christopher Apr 12, 2012 4:32 AM (in response to Ricardo Mota)1 of 1 people found this helpfulHi Ricardo -
You're looking for the equivalent of a RIGHT JOIN (Primary = Left, Secondary = Right), and unfortunately Blending doesn't support this.
If you make your Secondary DB your Primary, you'll be able to see all customers, at the cost of losing the use of your dimensions from the database that is now Secondary -- this won't work either.
Is there any chance you can actually do the join at the level of the data itself? For example, if this was SQL Server and two databases live on the same (or different) servers, you could do something like this:
Select PrimaryTable.*, SecondaryTable.*
FROM
PrimaryTable RIGHT JOIN SQLServerName.SecondaryDatabaseName.dbo.SecondaryTable SecondaryTable
ON PrimaryTable.Customer = SecondaryTable.Customer
-
2. Re: See all the customers in the DB even does who haven't values (Data Blending)
Ricardo Mota May 24, 2012 9:33 AM (in response to Russell Christopher)Hi Russel
Sorry for this late thanks, but I didn´t see your post.
I will try with the help of some friends and let you know something.
Thank you once again
RFM