In ICE#9 “join4” we combine the join3 table and the customer…
In ICE#9 “join4” we combine the join3 table and the customer master table using the variable CustID and an inner join. This results in a table with 1,168 observations. If we instead link this tables using a left join and the TerritoryID variable, we get a table with 18,937 observations. This increase in observations happens because TerritoryID does not uniquely identify observations in the customer master table.
Read Details