Normally data blending will work correctly when you have the same number of columns in two data sources and the values inside these columns are case sensitive. For ex: in data source 1 if the state is like Arizona and in data source 2 it is like arizona in that case the results wont appear or its not correct.
Like that we need to check whether the values are correct in the both the columns between two data sources.
You can do this practice by dragging and dropping the blended columns in one sheet and check whether both the values between the sources are same or not.
Hope its useful.
I can't open your workbook because I am using Tableau 9.1
Cross check the data in the excel sheets and check whether data is matching or not, as 'kumar' said check for case sensitive.
I am using earlier version not able to open the workbook.
Please check your numbers and see if it is actually reporting incorrectly. This is from 'Main Sheet', where you get your Occupancy:
And this is when the data behind the blend is expanded - showing the blend fields:
Your joining fields are questionable as I assume there should be some time based blending required as well if trying to join to an event - the way you're joining is showing Occupancy overall for the Zipcode/State combination.
For your interest adding a join from Start Date to Date gives the following:
Many thanks for lighting this up. As you have showed I have blended the data now on the dates. However now as you see from some of the events the occupancy is coming as null. When I check the excel sheets that shouldn't be null at all.
Eg : Event Name - "Atlanta Hawks - Chicago Bulls"
The tableau report shows null however the excel file shows there are data.
Can you please advise me how to rectify this? I have attached the excel files.
Thank you for your reply.
Actually The Column numbers are different here. I am trying to blend the data set on Date, State and the post codes.
Event data set includes the event date and the event name and the location ; The hotel booking data has booking date, hotel name & location, Occupancy.
I am trying to derive as on 01-Jan-2015 Id there is an event on post code 70707 then what was the occupancy of the hotel at the postcode 70707 for the same date. Any idea how to overcome this issue?
As Andrew suggested I am getting the data for some events but some are blanks now.
Yes, blending on dates can sometimes gives unexpected results - check out this post: How to join - data blending - date fields in Tableau
Change the joins to as follows and it should work better:
To help sense check the numbers I recommend putting the Start Date field into the data you can manually check whether right or wrong numbers are being returned and whether your joins need to be further tweaked: