1 of 1 people found this helpful
It sounds like you may be on the right path, in regards to suspecting the values don't match exactly between the 2 databases. It's hard to be sure however, without looking at the data/workbook.
To answer your question about how to force the pairing, you may be able to use an 'alias' for each value on your database. The process is described here: Example – Editing Aliases. If you manually setup the exact same alias for fields on both of your data sources, blend should work. That would confirm your suspicion!
If you are more familiar with JOINs, an alternative to blending starting version 10 is to use cross database joins: Quick Start: Combine Tables Using Cross-Database Joins
Hope this helps!
Thank you very much for your advices.
But I'm sure that the values match exactly between the 2 databases. I used the VLOOKUP formula in Excel to verify it.
And I can't use cross database joins, because my databases are details databases by offers on supply's market and by deals on the take-up market : two differents data I can't blend. I can't determine an index to match the two databases.
I'm still searching for my answer. =)
Could you share a sample workbook (twbx) that's presenting the problem? It doesn't need to be the complete or real data, just an example with the issue. Here's an idea on how to anonymize your data: Anonymize your Tableau Package Data for Sharing