filtering columns by a row value
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
both solutions work, thank you so much 😁
