Alteryx Designer Desktop Discussions

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

Remove not duplicates

Ultralightbeam
8 - Asteroid

Hello guys I want to delete entire row with single entry

Input:

NameIDDateGrade
Alyssa12021-01-224
Alyssa262021-02-055
Alyssa452021-01-084
Dy62021-01-224
Edrose332021-02-055
Fatima92021-01-225
Fatima372021-02-055

 

Desired Output:

NameIDDateGrade
Alyssa12021-01-224
Alyssa262021-02-055
Alyssa452021-01-084
Fatima92021-01-225
Fatima372021-02-055
18 REPLIES 18
Emil_Kos
17 - Castor
17 - Castor

Hi @Ultralightbeam,

 

Can you review and let me know if this works:

 

Emil_Kos_0-1613576834007.png

Output:

 

Emil_Kos_1-1613576862274.png

 

Ultralightbeam
8 - Asteroid

@Emil_Kos Thank you so much for saving me!! Have a great day!!

Emil_Kos
17 - Castor
17 - Castor

Hi @Ultralightbeam,

 

No worries. Actually, without your detailed explanation, I would never complete it.

 

I wished more people would provide so granular level of detail. 

 

Wish you luck and I hope I will have the opportunity to help you more in the future. 

Ultralightbeam
8 - Asteroid

@Emil_Kos I just notice that if the provider is at bottom part it shouldn't be included on the output.

Ultralightbeam_0-1613577820882.png

I have included sort by provider

Ultralightbeam_1-1613577851083.png

 

Emil_Kos
17 - Castor
17 - Castor

Hi @Ultralightbeam,

 

That means it works for you now or you need any help? 😆

 

Ultralightbeam
8 - Asteroid

@Emil_Kos 

 

I am about to give up lol

Output should still be the same as yours even a row with same provider is at bottom part

Emil_Kos
17 - Castor
17 - Castor

Hi @Ultralightbeam,


I made small change in the sort order

Ultralightbeam
8 - Asteroid

I just figured out i was ascending a different column.

 its 12 am here and been doing alteryx for more than a day now. Thanks for your help I will sleep now and continue tomorrow.

Emil_Kos
17 - Castor
17 - Castor

Hi @Ultralightbeam,

 

Sleep well 🙂 


I am not sure if due to the time zone difference I will be able to help you but feel free to shout for me if needed 🙂  

Labels