Distribute randomly

Hello!

I have two tables like the ones below. Could you please help me with an idea? In Table 2, I need to randomly redistribute one agent according to the team. Do you have any idea how I can do this? I tried with the Join node, but it didn’t work correctly :slight_smile:

| Table 1    |            |
| Agent Name | Team       |
| James      | Sales      |
| Emily      | HR         |
| William    | IT         |
| Olivia     | Operations |
| Alexander  | Sales      |
| Sophia     | HR         |
| Benjamin   | IT         |
| Charlotte  | Operations |
| Henry      | Sales      |
| Grace      | Operations |

| Table 2   |           |            |
| item List | Team      | Agent Name |
| Item 1    | Sales     | James      |
| Item 2    | IT        | Wiliam     |
| Item 3    | Operatios | Olivia     |
| Item 4    | HR        | Sophia     |
| Item 5    | Sales     | Alexander  |
| Item 6    | IT        | Benjamin   |
| Item 7    | Operatios | Charlotte  |
| Item 8    | HR        | Emily      |
| Item 9    | Sales     | Henry      |
| Item 10   | IT        | Wiliam     |
| Item 11   | Operatios | Grace      |
| Item 12   | HR        | Sophia     |
| Item 13   | Sales     | James      |
| Item 14   | IT        | Benjamin   |
| Item 15   | Operatios | Olivia     |
| Item 16   | HR        | Emily      |
| Item 17   | Sales     | Alexander  |
| Item 18   | IT        | Wiliam     |
| Item 19   | Operatios | Grace      |
| Item 20   | HR        | Sophia     |