Issue
After adding a join clause using join calculation to a union of tables, the following error might occur"Unable to change the join clause information for <file name>. Unable to update relation"
Last Modified Date: 22 Mar 2018
"Unable to change the join clause information for <file name>. Unable to update relation"
Environment
- Tableau Desktop 10.3.1
- Text Files
- Excel
Resolution
The order of operation to join data connections and also union tables needs to follow these steps:- Drag the first .csv (or .xlsx) file to the Data pane.
- Drag the second .csv (or .xlsx) file that you wish to join.
- Then create the Join Calculation.
- In the attached example workbook Union Solution.twbx, the join calculation clause is "K" and the associated join is "Key".
- Finally, drag the last table beneath the first table in the "Drag table to union" field.
Additional Information
For more information about data join and data union, see the following Tableau Help articles:Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials