IssueAfter 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"
ResolutionThe 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 InformationFor more information about data join and data union, see the following Tableau Help articles: Union Your DataUse calculations to resolve mismatches between fields in a join Discuss this article... Feedback Forum
Did this article resolve the issue? Thank you for providing your feedback on the effectiveness of the article. Click here to return to our Support page. Open new Case Open a new case Continue Searching Click here to go to our Support page. Knowledge Base Get detailed answers and how-to step-by-step instructions for your issues and technical questions. Community Find and share solutions with our active community through forums, user groups and ideas. Product Help Browse a complete list of product manuals and guides. Available online, offline and PDF formats. Training and Tutorials Learn how to master Tableau’s products with our on-demand, live or class room training.