Also, just to clarify on point 2)
To be noted that I can easily change the excel file data type to date & time, and it will work without problems. However, this I feel like I shouldn't have to use a "workaround" in this case. So perhaps it is simply a bug?
And point 1) still remains an issue.
1 of 1 people found this helpful
Indeed, join on calculations is not currently supported - keep an eye on upcoming Betas though.
And you are absolutely right about the type switcher - it only "works" on Text and Excel but only because for those two we reparse files to bring data in the data type specified. For everything else type is "applied" only at the very top of the data model and does not affect join conditions.
p.s. Imagine the opposite case when you join two tables on the Integer column but then in the viz you'd like to format (and use) it as a string? Would it be OK for us to break the join?
Thank you for the answer, that's what I was thinking.
Join on calculations is a must for us for future projects, is there any ETA on that features in the upcoming betas?
Of course there is - we take our development seriously.
We are not allowed to disclose it though ¯\_(ツ)_/¯ (for various reasons)...
I bet you understand!
Of course, still had to try
So, here we are at the end of 2017 and we are about to begin using Tableau Desktop 10.4. Does this version support cross database joins on calculated fields or not?
Thank you for responding.
Tableau, since version 10.2, support cross-data based joins on calculations in most cases.
However, note that you cannot actually select the calculated field, you need to write the calculation directly in the join.
OK Antoine, I will give it a try and report back with the results.