A Data Analyst has the following primary data source that contairis a dimension named Dorm_Code.

Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dorm_Name_New] in the calculation window.

Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source.

Bring in the secondary data source as a union.

Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name, select Replace References, and then select Dorm Name New.