**Aggregate order rows by a criterion

ekaterinagalin88

Dear Community,

Please help me solve the following issue:

For each order I have several rows. I need to separate those orders where at least one of the values for 'promo' column is 'Christmas', keeping all the rows that belong to that oder. (Please see the screenshot attached)

Thank you!

AngelosPachis

Hi @ekaterinagalin88 ,

One way to do that would be to use a filter tool to get all columns that contain christmas, and then use a join tool to join on the order number. Orders with christmas should fall out of the J output anchor

Hope that helps,

Angelos

example.yxmd