Settling bulk values after filter

[Abhii2658]

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. 

[atcodedog05]

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]

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 · Accepted solution]

Hi @Abhii2658 

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

Workflow:

Hope this helps : )

[Abhii2658]

Done, thanks Mate ! 

Cheers. 

[atcodedog05]

Happy to help : ) @Abhii2658 

Cheers and have a nice day!

[Abhii2658]

Can i friend you on FB or Ins or Twitter ?