In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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