filtering columns by a row value

Question

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 Answer

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 Answer

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