2 of 2 people found this helpful
the only way to do this is to make the excel sheet your primary source in this example. data blending only works when there are relationships defined. in this situation tableau does not know how atp id is related to ntp reference. this is not a left outer join as in most common databases. you can achieve the desired functionality in v10.0+ though through cross database joins.
Please find the below community chain.
As suggested by Chris you can use cross joins functionality which is available from tableau 10 version to get the desired output.