**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 · Accepted solution]

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