Multiple rows per order with various volumes in various columns - need just one row per order

[kadabrada]

Hi

I got a tricky data set with multiple rows per order, where data is repeating but not for every column equally. I need to find a way to merge them into 1 row per order.

Any tips on how to get the desired result as specified in the screenshos? 

[BA_Pete · Accepted solution]

Hi @kadabrada ,

It looks like you can just group on [OrderItemID] and set all other fields to MAX, although I'm not sure how you decided which value to keep from your [Custom] column.

Pete

[v-yalanwu-msft · Accepted solution]

Hi, @kadabrada ;

As  BA_Pete  said, you could group by OrderltemlD; then other column as max.

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BA_Pete · Accepted solution]

Hi @kadabrada ,

It looks like you can just group on [OrderItemID] and set all other fields to MAX, although I'm not sure how you decided which value to keep from your [Custom] column.

Pete