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 (2.8 MB)

I managed to do it using the Loop format

1 Like

Nice work! Thanks for sharing your solution :+1:

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