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
