Mark orders with a value

[ulysses_no]

Hi all!

I have a dataset that contains ORDERS with SKU and BRAND. 

I want to:

- IF a ORDER contains BRAND = Philips Hue THEN I want to MARK all the lines within the order with "YES"

For example:

ORDERNO  | BRAND | SKU

1  | Philips Hue | 200

1  | Apple | 300

1  | Microsoft | 400

Wanted result:

ORDERNO  | BRAND | SKU | HUE FILTER

1  | Philips Hue | 200 | YES

1  | Apple | 300 | YES

1  | Microsoft | 400 | YES

I have tried but only manage to mark the Philips Hue line and not every line 🙂

[atcodedog05]

Hi @ulysses_no 

Here is how you can do it.

Workflow:

1. Using filter tool to filter only rows with Brand Philips Hue

2. Using count record to get count of record with Brand Philips Hue

3. Using find and replace tool to map the count to order

4. Using formula if count>0 (I,e at least one row Brand is Philips Hue) the Flag HUE FILTER as yes

Hope this helps : )

[RolandSchubert · Accepted solution]

Hi @ulysses_no ,

you can select the oder lines cvontaining "Philis Hue", create a list of orderno and Join this list to the complete orders list:

Let me know if it works for you.

Best,

Roland

[ulysses_no]

Both solutions works, but Rolands was easier for me. Thank you both for using your time to help me ❤️ 

[atcodedog05]

Happy to help : ) @ulysses_no 

Cheers and have a nice day!