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

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