Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

filtering columns by a row value

hilsiahr
6 - Meteoroid

Hi everyone

 

im struggling trying to do this 

 

so the problem is the following: I have an excel with N number of columns and in the row 5 I will know if a column is mandatory or not with the value "Required" if the column is required i want to know if those columns have nulls or blanks or they are completely populated

 

hilsiahr_0-1674593151854.png

any help is welcome

 

thanks!

3 REPLIES 3
kathleenmonks
Alteryx
Alteryx

Hi @hilsiahr 

 

I've attached a workflow that I think might help solve your problem. The steps I took are:

 

1. Select Records Tool: Select only the row that contains whether or now the column is required - in my example row 4. 

2. Transpose to field name and required info

3. Dynamic Rename to add the required row as the description in the metadata

4. Dynamic Select with a formula to only choose the columns designated as "required" in the description

 

Let me know if this helps or if I have misunderstood your problem.

MatthewO
Alteryx
Alteryx

@hilsiahr the attached example is one approach to solving this. I hope this is helpful for you.

 

image.png

hilsiahr
6 - Meteoroid

both solutions work, thank you so much 😁

Labels