Filter on multiple fields

Question

Hi,

I'm looking for a solution for this problem:

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

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.

Istwineres · Answer

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

JosephSerpis · Answer

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

Blanks_18022020.yxmd

philipmannering · Answer

Hi @Istwineres

The solution will probably look like,

Hope that helps.

P

Exclude blanks.yxmd