I have combined two separate workflows using the union tool and when I look at the output from the union tool I my account numbers are not combining. Rather half way through I am getting null and them a column of my account numbers. I have attached my workflow if anyone can resolve this issue. Thanks!
Solved! Go to Solution.
@mmh2023 really subtle issue here but the fact that they wouldn't Union suggests the names are different, even if very slightly. When double checking, I noticed that when you renamed the field in this Select tool, you left a trailing space on [Account] to make it [Account ], hence why it won't Union to [Account]:
I've just done another rename in the final Select before the Union to bring the 2 in line:
And we get our expected result:
Amended workflow attached.
Thank you!