Rim weighting (a.k.a. iterative sum weight / update weight based on a set of rules in another table) help

Hi together,

I build something, because I thought this a fun brain teaser. My main problem was to use the updated table in the loop again. Because I don’t know better I used a in memory database.

The workflow is not beautiful but it seams to work. You just have to execute the last “DB Query Reader”. In the Recursive Loop End" you can modify the amount of iterations.

update_weight.knwf (106.8 KB)

I´m really curious what @Thyme build because I think he has a lot more experience with this sort of things and I would like to learn.

Just by the way, I can’t put the flow on the hub, because my vpn blocks some connection.

Best regards,

Paul

PS: Also I used the variable connections not for the actual varibles, but to ensure the right order of executions!

1 Like