Alteryx - Random column filler

Hello everyone!

I'm new to this community but very happy to join. For a project on excel I want to automate the division of jobs among different teams. I have a column that labels each task as "daily" and I would like Alteryx to create a new column which counts the number of "daily" in the sheet and basically split the tasks among 8 teams. The final output would be another column in which of the tasks are 80, the first 10 raws would contain "group1", the next 10 "group 2" and so on.

I'm still new to Alteryx so thanks a lot for the help!

Workflow

Accepted answers

Pingu

Hello @Lollino , for me it is not fully clear what you need. But what about this?

Fix 8 teams.yxmd

All comments

mbarone

Do you have a mock up of incoming data and the results you'd want? Might help to see an actual example.

Lollino

For example, the first print has to turn into the second one

I hope that in this way is clearer but basically all the tasks marked as daily have to be assigned proportionally (not perfectly tough) to the 8 teams.

Pingu

Hello @Lollino , for me it is not fully clear what you need. But what about this?

Fix 8 teams.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317