Last Modified Date: 09 Jan 2019
Environment
- Tableau Desktop
- Data Blending
- 2 Data Sources with Identical Data Structures
Answer
- Go to Analysis > Create Calculated Field.
- Name the calculated field and in the Formula field, enter the following:
IF ATTR([<Primary Data Source Field to Compare>]) = ATTR([<Secondary Data Source Field to Compare>]) THEN 'Same' ELSE 'Different' END
- Click OK.
- Drag the calculated field to the Color shelf on the Marks card to create a view that shows which fields match and which fields are different between the two data sources.
Additional Information
For more accuracy, include more comparison clauses to represent more common fields between the two data sources. For example:IF ATTR([<Primary Data Source Field to Compare>]) = ATTR([<Secondary Data Source Field to Compare>]) AND ATTR([<Second Primary Data Source Field to Compare>]) = ATTR([<Second Secondary Data Source Field to Compare>]) THEN 'Same' ELSE 'Different' END
Discuss this article... Feedback Forum
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