We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Tricky Formula/ Tool Question with Workflow

Cferrer6
8 - Asteroid

Hi Alteryx Community. 

 

I have a tricky problem that i need help solving. I have a input report that has multiple "orders" with in each order there can only be equal or less than number of "deployment fees" than Clover Flex Gen's. If there are more i want to use alteryx to zero them out. Attached is a flow that completed that task but only for a single order. How can i complete the task if there are multiple orders in the data set. Any help is greatly appreciated!

 

Thank you in advance. 

 

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @Cferrer6 

 

It might be something like this. I am still unclear with your logic.

 

atcodedog05_0-1633366582515.png

 

If this doesn't work please explain the logic and provide the expected output.

 

Hope this helps : )

ChrisTX
15 - Aurora

Use a batch macro.  Pass in each Order number.

 

Watch the videos on this page for Batch macros: https://community.alteryx.com/t5/Videos/Video-Training-Index/td-p/45161

 

Chris

 

Cferrer6
8 - Asteroid

yes it worked!! Thank youuu

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Cferrer6 

Cheers and have a nice day!

Labels