What is the best approach to combining data from two tables (Actuals and Forecast in the example below), so both the Actual and Forecast field are available in the resulting table when some rows match and some don't.
Merging using a full outer join results in the following:
Would you then just create a new name field something like this:
Taking the value from Name if it's not null or from Forecasts.Name if Name is null.
Resulting in this:
Which can obviosuly then be tidied up:
Is there a better way of achieving the same thing?