SOLVED
Append Two Data sets with different fields
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
TimD1
5 - Atom
‎11-26-2019
07:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am sure there is a simple solution to this, but I am attempting to append two data sets with a mix of similar and different field headings. I simply want the 'different' fields to be added as per the example below. Is this possible at all?
Thanks in advance!!
Set A:
Set B:
The output I want - Set A+B:
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
2 REPLIES 2
MichalM
Alteryx Alumni (Retired)
‎11-26-2019
07:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you use the Union tool in its default setting - autoconfig by name - you will achieve what you need.
echuong1
Alteryx Alumni (Retired)
‎11-26-2019
07:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use the union tool to achieve this. It will essentially combine all fields and all records. Let me know if that works!
