Join 2 data sets with conditions - automated task assignment logic

[Machan1121]

Hello, I was wondering if there is a solution to my problem, hopefully someone can help me, I was trying to build a workflow that involves 2 data sets. the purpose of this workflow if to auto assign workers to tasks. I have 2 data sets, first is the worker_list with columns (worker_id, worker_name and asset(the technology the worker is expert on)). second is the work_tickets, this are the unassigned work tickets that needs to be assigned with workers, it has columns (work_id, requestor, asset and assigned_worker(to be populated)). 

- I was trying to figure out how I can assign each work tickets to worker so that each ticket will only have workers with the same asset as the request. requests with same requestor must be handled by same worker, and once a worker has been assigned a work, the next ticket with different requestor should be assigned to a different worker with matching asset. 

Sorry for my bad English, hopefully I was able to explain what I was trying to achieve. Thank you in advance for those who will help out

[ntakeda · Accepted solution]

@Machan1121 

I have created a workflow.
If the requestor and asset have the same work_id, the same worker will be assigned.
Otherwise, the worker with the least assignments for the same asset will be assigned.
Please refer to the workflow for details.

[Machan1121]

@ntakeda Thank you for the help, it works nicely as you explained. I was wondering what version of alteryx you created this workflow because for some reason whenever I try to open it, it says it is created in a more recent version of alteryx. I'm using 2023.1 version

[ntakeda · Accepted solution]

@Machan1121 

I'm happy I could help solve the issue.

I'm using 2024.2 version.