One Row Per Order On Multiple Status

[Asimkz]

Hi All,

I have data set that contains a order number and the order steps that show what each order went through before being processed. I would like to be able to have the step field in one line per order. In my example screenshot the OBJNR is the order number and STAT is the step column. It’s one order but in the dataset it’s broken out into multiple lines and I’m hoping there is a way to put it all in one row.

I have to join this dataset to another on order number but because of the way it’s structured it’s creating a one to many join and bringing back duplicate measure values.

[ArjenEX]

Hi @Asimkz

Welcome to the KNIME Community!

For this, you can use the GroupBy node whereby the Group is objnr and the aggregation is on stat. Select Concatenation or a variant of this as the method of aggregation.

Input:

Group

Aggregation

Output:

Hope this helps!

[Asimkz]

Thank you so much. That worked perfectly