Hi all,
For several months now I've been successfully filling holes in data sets with judicious use of the Select tool in the Join tool, and a Union of the 3 outputs.
I do this by unselecting the Right inputs that I want replaced in the Join:
and then Unioning the 3 outputs R, J, L.
What's puzzling to me is that the R output (and I suppose L as well) is different depending on whether or not there is a Union following the Join.
I would expect the Right and Left outputs to be simple subsets of the Right and Left input record sets, without alterations to the column structure. This is indeed what happens when I have a Union tool directly after my Join, so my operation, in all, comes out like the picture above.
However, if I don't have a Union tool following the Join, the Right output acts as if the select has been applied to it! -- Here, the Right output doesn't have the Result A column.
I sure hope someone can explain this.
I've attached the example workflow.
Thanks!
Jennifer
