counting and grouping

Good afternoon everyone, how are you?

I need help to do this project.

I separated by color, but I need you to create a count up to 17 according to the SOC and region columns.

After that, I need you to group and add the values ​​in the orders column and create a “route” column that is done behind the SOC + “-” + region + “-” + what is the route number for that region.

KNIME_project(2).knwf