We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to allocate the data evenly?

itsyhq
5 - Atom

Hi guys, I'm new to alteryx and I'm facing difficulties in trying to allocate my data evenly. I have a set of data that I have to split in 2 rounds. In the 1st round, I'll have to filter out "apple" and split it evenly among Amy and Andy. The 2nd round requires me the filter out everything but "apple" and split it evenly to Amy, Andy, Rachel, Ahmad and Eve. However, I have to take it into consideration that Amy and Andy have already the "apple" data on hand, hence they should not be overloaded. Everyone should have equal number of data at the end of the day. I have attached a sample data, please help me!!!! Thank you 🙂

2 REPLIES 2
Christina_H
14 - Magnetar

Two options attached.  My first attempt used an iterative macro, but if you're new to Alteryx that might not be easy to follow!  I then came up with something different to make it possible in a standard workflow.

itsyhq
5 - Atom

It works! Thank you so much 😊

Labels
Top Solution Authors