Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop 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