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 🙂

Datasets

Dynamic Processing

Preparation

Accepted answers

RolandSchubert

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

MarkOrders.yxmd

All comments

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 : )

HUE FILTER.yxmd

RolandSchubert

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

MarkOrders.yxmd

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703