How to append a table with values from another table

I previously worked on a project where we have a table of cases and we predict the group it goes into based on the case description through Python. We were able to do this successfully but now we are trying to assign some people to work on each case based on the prediction.

I have thought about separating the groups first using rule-based row filter, and then using a simple rule engine (if group=a, then input agent A) but there are many agents within one group. The caveat is to be able to assign cases to each agent more or less equally, looping through each case within that group.

Case table
image

Agents table
image

Expected outcome should be the case table with an appended column that loops through each agent.

I tried to look up other posts but there seems to be no topic opened for this yet.

Any ideas are welcome!

Hi @garefareal,

try to use a random matcher node. Here is an example:

Have a nice evening,
Raffaello Barri
Let’s connect on LinkedIn!

I tried to create a sample workflow on this but the table outcome isn’t quite right. The agents aren’t being looped after the first iteration and thus creating blanks in the table.
image

Here is the workflow:
Loop names.knwf (40.0 KB)

Using the random matcher node will result in uneven distribution of cases, so that one’s out :frowning:

1 Like

Hello @garefareal,

this waas interesting! Although loop is a what first might come to mind here is a way without it. Idea is to bring list of agents on project and then pick one by one from the list using mod function for which you need rank inside project and count of agents on project.

How to append a table with values from another table_ipazin.knwf (18.4 KB)

Hope this helps!

Br,
Ivan

2 Likes

That totally worked, thank you so much!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.