Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Join of two exact same files.

aishwaryapan
5 - Atom
‎04-07-2023 01:18 AM

Hi all, 

I need to merge two files which has exact same  coloumns in both but the datas are different. After using union tool it's making few duplicates. So I think join us the only option. But as there is no such unique field,I am confused what to do..

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
binuacs
21 - Polaris
‎04-07-2023 02:28 AM

@aishwaryapan If you want to merge the two files use the union tool and remove the duplicate records using the unique tool

 

binuacs_0-1680859731016.png

 

Reply
connect with mentors
designer new user guide
Labels
Top Solution Authors
View All