Question: 1/50
An analyst needs to combine an Excel file containing monthly targets with a database table containing actual sales. The two sources share a common field called Region. The analyst wants both targets and actuals available in the same view without altering the underlying data sources. What should the analyst do in Tableau?
Create a relationship between the tables using Region
Create a union between the Excel sheet and the database table
Pivot the monthly target columns into rows in the Excel connection
Create a table calculation to look up values across data sources