Settling bulk values after filter
- 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
I have a filter and based on the result of the filter i want to set the valuees of 50 fields to something.
For example all fields with TRUE outcome are set to "Out of Scope"
If there a way to do this in bulk without writing every field.
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Abhii2658
You can use mutli-field formula for this. Here is an interactive lesson on it.
https://community.alteryx.com/t5/Interactive-Lessons/Multi-Field-Formulas/ta-p/424422
Can you provide some sample input and expected output it will help us get a better understanding of the usecase.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Data looks like this
Total Records 11,000
Total fields 55
Filter
Field A = 0
Field B = 0
Field C = 0
Field D = 0
If the above are True then set all filtered records to "Out of Scope" (All 55 fields of them)
Hope i made myself clear
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Abhii2658
Here is how you can do it. Make sure its configured like below.
Workflow:
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Done, thanks Mate !
Cheers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @Abhii2658
Cheers and have a nice day!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can i friend you on FB or Ins or Twitter ?
