Data filtering question

[tbrook207]

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

[Anthony_Giesing]

Looks like a problem for the transpose tool. I made a POC using the transpose tool, filtering for items with nulls and removing them via the join tool. 

[ChrisTX]

See if the attached workflow works for you

Chris

[gjjadhao]

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

[jdminton]

@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".