1 of 1 people found this helpful
I replicated this but with 2 basic excel sheets and the data blending worked, could an idea be to try some custom SQL to join your 2 tables even if just to test?
Thanks for the quick response.
You're right - it works in excel.
But...Let's say I add another field to the first table - State (the state where the order was taken),
and I want to see two things:
Total sales per state AND quantity of each product sold in each state.
I get can't to see the quantity of products sold in each state, as Tableau says that there's no linking field. That's correct, OrderID is actually the linking field between the 2 tables, and State only exists in the first table. Any way to get it done with data blending?
I should point out I am using the Version 8 Beta 6 desktop version.. Wonder if that makes a difference?