When I use this workflow, I lose many lines. The total number of rows decrease for some reason

I am using this to fill in Managers in rows where the managers are not shown in historical data. The problem is, for some reason I end up with 217k rows instead of 225. Can someone please help me fix this?
Left Join List of Managers - KNIME Forum (78804).knwf (100.2 KB)

Hello @Menoufi,

When you try to do joins and if the relation is many to many then this sort of increase occurs. The reason is you do no have one unique key in both your tables. The file you have uploaded seems to be for the other topic you have on the forum.