Distribution of task

[DeanLascota]

Hi,

I am fairly new to the application, and I wanted use it on my daily role. Hoping someone can help me.

I usually get the generated file with a Task # on it, which are to be assigned to specific members of the team for review. I have gone through the data cleansing and stuff but I am stuck with assigning the tasks to each members, apparently I am doing this wrong as I have tried creating a blank column in the 1stwith the same column name of my reviewer data set but using join, append, and find replace tools don't seem to help. 

Please see the visuals below:

Generated data (data set 1)

Reviewer data set:

Expected Result:

Appreciate the help!

[chukleswk]

This may be a bit overkill for what you're looking for but it will adjust automatically based on how many Reviewers you have.

 

[DeanLascota]

Appreciate the help! Will check this out! 

Have a good day :)