Data filtering question

Question

Hello all

What would be the best method of filtering out empty / null rows from a workflow?  I know we can use the cleanse tool to clear our null rows, but it seems like this only works if the entire row is null.  I'd like to expand so that if any of the data in the row is null, it is removed from the output.  Screenshot is attached for reference.

Thank you

jdminton · Answer

@tbrook207 I'm not sure if this answers your question perfectly, but it sounds like you could use a filter tool with a custom filter. The below is if you need both values to be null before removing the record. To remove if either are null, switch the "AND" to "OR".

gjjadhao · Answer

@ChrisTX Thanks for posting your workflow, It solved one of my problem.

ChrisTX · Answer

See if the attached workflow works for you

Chris

Data filtering question.yxmd