Hi Russel, in addition to joining them or creating two separate data sources, you can union them: Combine Your Data with Union in Tableau 9.3 | Tableau Software
Creating two separate data sources has advantages and disadvantages, but a lot of that depends on your use case. In general, a single data source will be more resource-efficient than a similar amount of data processed from multiple data sources, but the actual difference depends on the circumstances. It might be too small of a difference to notice or measure. And it doesn't really complicate publishing.
And no, it does not complicate publishing. You don't need two separate XLS files. It'll work.
Thanks for the quick response.
Is it accurate that to have multiple sheets that are NOT joined, I would have to create multiple data sources?
I'm thinking that to simplify the architecture, I'll put each sheet in a separate xls, and treat them like separate "tables". I know the next challenge will be to join where I DO want a join. I expect that to be easy. :-)
I'm interested in any other models that people have used.
Thanks David and Joe,
Now I'm experimenting with separate xls files that have key relationships. A:B, B:C, and C:D. After joining, I expect to have A:B:C:D.
I'm trying this model to simplify migration to a database in the future, and create atomic data sources.
I see from the Learning videos that a Cross-Database Join can be performed by adding a Connection.
However, in our office we are still on 9.3.
I've searched the help, menus, etc, and am not able to find Cross "Database" joins in 9.3.
David, the Union info you shared looks like appending rows. In this case, I'd like to join on columns.
Russel -- Yes, non-joined XLS sheets are separate data sources.
And if you do that, then (in 9.3) if you want to build some relationship between them, you blend.
If you want to JOIN them in 9.3, as far as I know you have to have the sheets in the same XLS file.