How to fix Null on Account Number Column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Datasets
- Designer Cloud
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!
![](/skins/images/5A278AAD67B5F68761E04A0A1AFFBB3D/responsive_peak/images/icon_anonymous_message.png)