Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more 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 singular column

MWon
7 - Meteor

Hello all, I am trying to turn this table here and remove the duplicates, whilst preserving the relationships

User1Title1Summary1Code1
User1  Code2
User1  Code3

All of the data here is grouped together, and all I want to do is remove the duplicates of user1 such that there is only one instance of user, all while keeping the rest of the data as is. In this case, it would look like this 

User1Title1Summary1Code1
   Code2
   Code3

I've been trying to use a multi row formula for this, using the expression If [Row-1:User] = "" then [User] else "" endif

But I am having trouble doing this without compromising the rest of the data

Thank You in advance 

5 REPLIES 5
IraWatt
17 - Castor
17 - Castor

Hey @MWon,

Here is one way which works without a multirow formula:

IraWatt_0-1656541196423.png

Any questions or issues please ask :)
HTH!
Ira

 

DataNath
17 - Castor

How's this? Though I did provide the same solution in your other thread:

 

DataNath_0-1656541245931.png

 

Hello @MWon 

 

Another way using Multi-formula. Thanks!

 

christine_assaad_0-1656541397838.png

 

IraWatt
17 - Castor
17 - Castor

@MWon Apologies I misunderstood the question my first method removes duplicates from all columns. This way here works for just the first column:

IraWatt_0-1656541622695.png

 

binuacs
20 - Arcturus

@MWon one way of dong this

binuacs_0-1656542675845.png

 

Labels