Alteryx Designer Desktop Discussions

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

How to remove duplicates in one column but not a related one?

MWon
7 - Meteor

I have a data set that has two columns with related data. However, I've had trouble explaining the issue, so I've included an example below. 

 

Here is what it originally looks like: 

EntryAUnique1
EntryAUnique2
EntryAUnique3
EntryAUnique4

 

And I want to turn it into just this(or something similar that I can work with)

Entry AUnique 1
 Unique1
 Unique3
  

 

Moreover, I still want to maintain the relationship between these two columns, such that I would be able to know that Entry A is still related to Unique1-3, despite the fact that there is only one cell with Entry A in it

 

3 REPLIES 3
oly
Alteryx Alumni (Retired)

Hi @MWon ,

I would create a new column for the Entry Header only requirement and keep the original values on Entry to be able to do other matching/processing.

 

You need to use MultiRow tool (it's a little tricky, check interactive videos or Youtubes how to use it).

See example attached. Hope it works for you!

Best,

Oly

 

binuacs
20 - Arcturus

@MWon Another way of doing this with the Multi-Row tool

binuacs_0-1656453410177.png

 

Qiu
20 - Arcturus
20 - Arcturus

@MWon 
We can do something if we can ignore the number of tools. 😁

0629-MWon.PNG

 

Labels