Allocation of tasks to Analysts

[Deepak_064]

Hi,

I have two data sets; 1. Name and shift. 2. Task id and type.

I want to assign the names from 1st data set to the task id in 2nd data set. Names should be assigned to tasks in similar way how Playing cards are dealt. i.e. if there are 5 names and 7 tasks available, task 1 to be assigned to A,  task 2 to be assigned to B,  task 3 to be assigned to C,  task 4 to be assigned to D,  task 5 to be assigned to E, task 6 will be assigned to A and finally task 7 will be assigned to B. When the next allocation is being done, the new task should be assigned from C and not from A.

Input 1:

Name	Shift
A	APAC
B	EMEA
C	Late EMEA
D	APAC
E	EMEA

Input 2:

Task id	Task Type
XX1	Main
XX2	Create
XX3	Create
XX4	Create
XX5	Main
XX6	Main
XX7	Main

Output:

First Allocation:

Task id	Name
XX1	A
XX2	B
XX3	C
XX4	D
XX5	E
XX6	A
XX7	B

Output:

Second allocation:

Task id	Name
XX9	C
XX10	D
XX8	E
XX11	A
XX55	B
XX68	C
XX78	D

[aatalai]

@Deepak_064 you need to set up a min database tbh, take a look at the files attached hopefully it will help