filtering columns by a row value

[hilsiahr]

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

any help is welcome

thanks!

[kathleenmonks · Accepted solution]

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 · Accepted solution]

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

[hilsiahr]

both solutions work, thank you so much 😁