You have the following primary data source that contains a dimension named Dorm_Code.
You receive the following secondary data source that contains updated dorm codes.
You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.
What should you do?
To update the existing dimenstion named Dorm_Code with the new codes from the secondary data source, you should bring in the secondary data source by using relationships. You can then right-click the Dorm_Name field in the Data pane and select Replace References to point to Dorm_Name_New. This method maintains the integrity of the original visualization while simplifying the update process, avoiding the creation of unnecessary calculated fields.
Replace reference is the easiest way to replace/update the dimension. Answer should be C
Replace reference is the easiest way to replace/update the dimension. Answer should be C
C should be the answer, as replace references is easier. It is possible to do with B, but you'd be creating an extra dimension for no reason.
Replace reference
C is not correct as relationship is for multiple connections instead of datasources.
good point! could you please help on the right answer?