GroupBy not properly working

I’m using a Concatenate node to join 2 tables (they only contain an id and a json object) and then I use the GroupBy node to merge them. The OrderID is the column to group.
I don’t know why but is seems like the GroupBy is not doing anything.
Can someone help me to figure a way of doing this?

  1. Here are the 2 tables


  2. The table after Concatenate

  3. The table after GroupBy

1 Like

Hi @ZeCosgrove and welcome to the Knime Community.

It looks to me like the GroupBy is working properly. I’m not sure how you expected it to “merge them”.

It’s not clear what you are trying to do. Are you trying to get the shipping_address and items on the same line for the same OrderID? If that’s the case, then you need to do a Join using the Joiner node rather than doing a concatenate. Concatenate will just append the data from table 2 to table 1, and the GroupBy is not going to bring the records on the same line from 2 different columns - that is why when you configure the GroupBy, you can only choose 1 column at a time.

Just use a Joiner node instead of Concatenate, and you won’t even need anything else - you won’t need to do GroupBy.

5 Likes

Yup, that´s it, thanks

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