It seems like you might be better served by UNIONing this data, rather than joining it, but at the very least, the join should only be on question. Trying to match an end date from this year to an end date from last shouldn't return any results.
I apologize for my ignorance, but what is UNIONing? Why would that be better? How would I go about doing that?
1 of 1 people found this helpful
The union clause is used to combine two datasets / tables - SQL UNION Operator
It sounds like what you're trying to do is combine the two datasets here rather than actually join them together.
Joining these two datasets with a left join will join each individual record in the dataset 'Tableau Format' to matching records in 'IA 10.2013 Comparison Data' based on your join conditions.
This means you'll end up with a resulting dataset which has one or more records for each record in the 'left' table which contains columns from both the left and right hand side table.
If you would like to understand joins better, I'd suggest this guide- A Visual Explanation of SQL Joins
If after all this what you want is actually a union, there's a lot of threads on here with good union advice i.e. Re: How to import multiple excel workbooks
Ok so I have tried the UNION, but either I did not do it correctly, or it's not what I really needed. I attached a workbook in case that helps. I would like to be able to compare the satisfaction for each year. Any help you can give me would be great. Thanks.
The attached workbook uses blending, which is not a union.
In order to implement a union you need to use custom SQL which may be outside of your skill level. You can use custom sql in Tableau 8.2 by using the Legacy Excel Connector - Re: Hello, in version 8.2, where is the custom sql option in the excel workbook connection ?