Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Settling bulk values after filter

Abhii2658
8 - Asteroid

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. 

6 REPLIES 6
atcodedog05
22 - Nova
22 - Nova

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 : )

Abhii2658
8 - Asteroid

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 

atcodedog05
22 - Nova
22 - Nova

Hi @Abhii2658 

 

Here is how you can do it. Make sure its configured like below.

Workflow:

atcodedog05_0-1631868961956.png

 

Hope this helps : )

Abhii2658
8 - Asteroid

Done, thanks Mate ! 

Cheers. 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Abhii2658 

Cheers and have a nice day!

Abhii2658
8 - Asteroid

Can i friend you on FB or Ins or Twitter ?

Labels
Top Solution Authors