How to fix Null on Account Number Column

Question

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!

Alteryx Lab 1.yxzp

DataNath · Accepted Answer

@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.