Delete Blank Records with Duplicate IDs

[Fred22]

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!

[christine_assaad · Accepted solution]

Hi @Fred22 

Please check the below. Hope it helps. Cheers!

[Emil_Kos · Accepted solution]

Hi @Fred22,

Interesting case. I created a workflow for you:

The output:

If this is something helpful please mark as solved!

Good luck!

[Raj_Singh1 · Accepted solution]

Hi please see attached solution

[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!

[Raj_Singh1]

thanks @Fred22  for accepting it as a solution 🙂

[Emil_Kos]

Hi @Fred22,

Thank you for accepting my post a solution.

Good luck!