topic Re: Question for the group: Task Assignment Logic Help (FIFO Method in Alteryx Designer Desktop Discussions

Question for the group: Task Assignment Logic Help (FIFO Method

babuam — Thu, 13 Nov 2025 05:35:17 GMT

Hi everyone, I need help assigning tasks to staff based on category and task count using FIFO logic.

I have two sheets:

Task Sheet: Contains Task ID, Received Date, and Category (A, B, C).
Staff Sheet: Lists Staff Name, their Category, and the number of tasks they should be assigned.

📌 Example: If Staff1 is in Category A and has 5 tasks to be assigned, I need to allocate the earliest 5 tasks from Category A to Staff1 (FIFO method based on Received Date).

💬 How can I automate this assignment in Alteryx so each staff gets the correct number of tasks from their category, assigned in FIFO order?

Re: Question for the group: Task Assignment Logic Help (FIFO Method

AncientPandaman — Thu, 13 Nov 2025 07:33:10 GMT

generate each task capabilities to sort and join back to the task list.

Re: Question for the group: Task Assignment Logic Help (FIFO Method

babuam — Thu, 13 Nov 2025 12:17:29 GMT

I am not able to open the workflow. getting error message"Tool ID 1 is not the document"

Re: Question for the group: Task Assignment Logic Help (FIFO Method

babuam — Fri, 14 Nov 2025 05:23:02 GMT

Hi Community,

Is there any solution for this idea. please update here

Re: Question for the group: Task Assignment Logic Help (FIFO Method

Qiu — Fri, 14 Nov 2025 07:07:47 GMT

@babuam
I expanded the tasks for each staff and join with task list based on order of Staff name.
I think we may need a priority for assignment for staff within same category in actual situation.

Re: Question for the group: Task Assignment Logic Help (FIFO Method

babuam — Wed, 19 Nov 2025 10:11:54 GMT

@Qiu @Thank you for sharing the workflow.