Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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