We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to merge two data files that have similar data, but have different column titles

ElizabethBrunson
5 - Atom

Hello,

 

I am really enjoying using Alteryx, and appreciate the innovation this software provides to professionals in the data analytics field. As an aspiring accountant, I see the value of being of being proficient in this software. I have a question. When you have two different sets of data that have similar information, but they have different column titles. What is the best tool on Alteryx to merge these two files?

 

2 REPLIES 2
binuacs
21 - Polaris

@ElizabethBrunson Use the union tool with Auto Config by position 

 

binuacs_0-1679007905895.png

 

alexnajm
18 - Pollux
18 - Pollux

The Union tool! You can manually configure, or align by position if the names are different. 

Labels
Top Solution Authors