Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

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

Allocate data to given members

Lalaiah
8 - Asteroid

Hi,

 

I am working on the allocation part. Data should be allocated given employee IDs.( Ex. We have received 150 transactions so, it should be allocated among 4 persons on an equal basis) 

 

Regards,

Lalaiah Katam

5 REPLIES 5
Qiu
19 - Altair
19 - Altair

@Lalaiah 
Hope this one will make up to you😁

0311-Lalaiah.PNG

Lalaiah
8 - Asteroid

Hi, Thanks for the solution!!

 

I have added an allocation column manually, actually, my requirement is the allocation column should be allocated by alteryx itself if I will provide the employee numbers which we need to allocate.

 

Exp. 1, 2, 3.. are my employees my raw data is having A & B column so I need to allocate one by one with 1,2,3 employees.

 

Qiu
19 - Altair
19 - Altair

@Lalaiah 
Sorry about the misunderstanding.

See the revised one.

0311-Lalaiah-R1.PNG

Lalaiah
8 - Asteroid

Thank you so much got the expected result.🙏

Qiu
19 - Altair
19 - Altair

@Lalaiah 
Glad to help and thank you for the accept mark.😁

Labels