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

Delete Blank Records with Duplicate IDs

Fred22
8 - Asteroid

I have an interesting use case. I need to delete blank records with duplicated IDs only if some of the records have data.

 

Example: If record 1 has 3 values in the name column and one is blank i need to delete the blank record. 

 

Example 2: If record 2 has 3 blank values in the name column I do not want to delete any records.

 

I only need to delete the blanks if the name column has data. If the name column is 100% blank then I keep it blank. If name column contains data I need to delete the blanks. 

 

Data is attached.

 

Thank you!

8 REPLIES 8

Hi @Fred22 

 

Please check the below. Hope it helps. Cheers!

christine_assaad_0-1605195466051.png

 

Emil_Kos
17 - Castor
17 - Castor

Hi @Fred22,

 

Interesting case. I created a workflow for you:

Emil_Kos_0-1605195489790.png

 

The output:

 

Emil_Kos_1-1605195503005.png

 

 

If this is something helpful please mark as solved!

 

Good luck!

Raj_Singh1
9 - Comet

Hi please see attached solution

Delete null.png

Fred22
8 - Asteroid

Worked as expected thank you for the quick reply!

Fred22
8 - Asteroid

Worked perfectly and a simple workflow. Thanks!

Fred22
8 - Asteroid

Thank you for the quick reply!

Raj_Singh1
9 - Comet

thanks @Fred22  for accepting it as a solution 🙂

Emil_Kos
17 - Castor
17 - Castor

Hi @Fred22,

 

Thank you for accepting my post a solution.

 

Good luck!

Labels