community Alteryx IO MyAlteryx
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
Start Free Trial

Alteryx Designer Desktop Discussions

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

Removing Duplicates from Multiple Columns

ltsiartas
5 - Atom
‎02-02-2021 07:37 AM

I have a question about something that’s been driving me crazy and looked online but couldn’t find the answer.  Please see below for what I have vs what I need.  Any help would be greatly appreciated!

 

What I have

ltsiartas_0-1612280081981.png

 

 

 

What I need

ltsiartas_1-1612280081982.png

 

Reply
0 Likes
1 REPLY 1
joshuaburkhow
ACE Emeritus
ACE Emeritus
‎02-02-2021 08:02 AM

Hi @ltsiartas 

 

You want to use the summarize tool to group by the id and Name. 

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
Reply
0 Likes
Community Live Fifa Workshop
Labels
Top Solution Authors
View All