We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Dynamically Filter Columns for Nulls

Kristinbell
7 - Meteor

I have a workflow that processes upload templates, example attached. The users can enter data between columns D and K, but they have to fill it out for the entire column. In this example, they filled out columns F and G. I'm removing the columns that are fully null. However, I want to filter on the remaining to columns for rows with nulls. In this example, row 4 for PROD7777 to kick it out as an error. The problem I'm having is that users are able to fill out as few or as many columns between D and K that they would like. Is there a way for me to dynamically filter columns for nulls in columns that are partially populated after I remove null columns?

2 REPLIES 2
usmanbashir
11 - Bolide

@Kristinbell - see attached workflow. Let me know if this is what you were looking for. Hope it helps!

Kristinbell
7 - Meteor

That's perfect, thank you!

Labels
Top Solution Authors