ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Union tool

janety0127
7 - Meteor

I need to match the field names of a current year template to a prior year template and output the names of new fields on current year template. Is there a way to use the union tool to output fields that do not match? I only see an option to output common sunset. Thanks.

2 REPLIES 2
apathetichell
20 - Arcturus

click where it says "output common subset of fields" and you should be able to  switch to "output all fields"

messi007
15 - Aurora
15 - Aurora

@janety0127,

 

Take a look on the example on the union tools,

You can manage to display which data stream to display first:

messi007_0-1618150832170.png

Below how you can chose the data stream order:

 

messi007_1-1618150935857.png

Hope this helps,

Regards,

Labels
Top Solution Authors