Filter on multiple fields

[Istwineres]

Hi,

I'm looking for a solution for this problem:

Field1  |  Field2  |  Field3  |  Field4  |  Field5  |  Field6

---------------------------------------------------------------------

     a     |     b       |     c      |       d     |   blank   |   blank

     a     |     b       |     c      |      d      |      e       |      f

     x     |      y       |     z      |      w     |     p       |      q

     x     |      y       |     z      |      w     |   blank   |  blank  

How to keep only the row that has all fields without blanks.

[PhilipMannering]

Hi @Istwineres 

The solution will probably look like,

Hope that helps. 

P

[JosephSerpis]

Hi @Istwineres I came up with an approach to tackle I've attached the workflow let me know what you think?

[Istwineres]

Sorry for the late response, maybe I wasn't clear enough but I'd like to keep the records without blanks and even if just one field has value keep it. In the original the desired output would be:

a | b | c | d | e | f

x | y | z | w | p | q