1 of 1 people found this helpful
The upper limit on how many rows you can blend probably depends on a few things, but I would be very surprised if you could blend the sort of numbers you are talking about. There are a few things you could look at:
Are you running on a 64 bit version of windows? That just makes a lot more memory available to tableau than 32 bit windows.
How many distinct email addresses in datasource 1 and how many in datasource 2 that have that other field present. Whichever numbe is smaller should probably be the primary datasource.
It is just possible that version 8 might help. If you only want the total you don't need to put email on the view in version 8. Tableau still has to do much the same under the covers, so I'm not hopeful, but it might just be more memory efficient.
Failing that all I can suggest it's putting both sets of data into the same database.
Hi Guys, Thanks for the reply.
I tried several ideas along the 'might just work' path in 8, without email field in view (in fact, I even tried your Distinct Count (http://community.tableau.com/thread/109935) method on an ATTR from the other side of the blend, and found that It just isn't going to be happy giving me an answer.
Will work on trying to get that stuff all into the same database so I can do a proper join.