Delete Blank Records with Duplicate IDs

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!

AlteryxQuestion.xlsx

Datasets

Accepted answers

Christine_Assaad

Hi @Fred22

Please check the below. Hope it helps. Cheers!

Delete Blank Records with Duplicate IDs.yxmd

Emil_Kos

Hi @Fred22,

Interesting case. I created a workflow for you:

The output:

If this is something helpful please mark as solved!

Good luck!

Interesting.yxmd

Raj_Singh1

Hi please see attached solution

Delete null.png

Delete Blanks if null.yxmd

All comments

Christine_Assaad

Hi @Fred22

Please check the below. Hope it helps. Cheers!

Delete Blank Records with Duplicate IDs.yxmd

Emil_Kos

Hi @Fred22,

Interesting case. I created a workflow for you:

The output:

If this is something helpful please mark as solved!

Good luck!

Interesting.yxmd

Raj_Singh1

Hi please see attached solution

Delete null.png

Delete Blanks if null.yxmd

Fred22

Worked as expected thank you for the quick reply!

Fred22

Worked perfectly and a simple workflow. Thanks!

Fred22

Thank you for the quick reply!

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235