In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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
21 - Polaris

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

binuacs_0-1656453410177.png

 

Qiu
21 - Polaris
21 - Polaris

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

0629-MWon.PNG

 

Labels
Top Solution Authors