Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter

NBPSE
8 - Asteroid

How do I add a filter that picks up data that "Contains Total" OR "Is Null" / No Data Found.

 

I have 2 inputs, one will sometimes be blank, but will sometimes contain a row Total that I need to use. Currently no NULL data is coming in, it is just not bringing any data in because the worksheet is blank and therefore it is causing my basic "Filter" icon for "Filter for if Contains Total" to error out my workflow. It says "No Applicable Data Found."

10 REPLIES 10
NBPSE
8 - Asteroid

Thank you @jirikrecek . When I originally tried the solution it was breaking my join further in the workflow, but I moved my filter and select down the workflow after the blank output and the fixed my error. Thank you so much for this solution, it works perfectly!

Labels
Top Solution Authors