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!
Solved! Go to 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.
both solutions work, thank you so much 😁