Tricky rules-based addition of a column

Hello!
My issue is this..

So in my data, I have each row classified by a "Channel". I also have a 2020 FY NSV by Operator Column.

I want to basically add in "Size" from the Size Rules Sheet - depending on what Channel is in the data.

So for example, Row 2: Arbys, the Channel is A, and because 2020 FY NSV is >4, I want it the column G "Size" to read "4+".

But then for Row 3, the Channel is B, and because 2020 FY NSV is

Note that I have 5 channels, and multiple ranges (e.g. 4-5) for each. The problem is, these are subject to change, so I want to be able to make a change to my input file "Size Rules", and then be able to rerun the flow.

Thank you for the help in advance

Test3.xlsx

Datasets

Dynamic Processing

Accepted answers

atcodedog05

Hi @hopex1229

Just adding to @clmc9601 solution. You can use pre exitsing dynamic replace tool inplace of CREW dynamic formula.

Workflow:

Hope this helps : )

Dynamic Formula Categorization hopex1229.yxmd

All comments

clmc9601

Hi @hopex1229,

If you haven't downloaded the CReW macros, they come in very handy for times like these! Dynamic Formula seems to me like a great option for this use case.

Check out this workflow and see if it helps. If it does, please consider marking this as a solution so others may find it! I'm happy to answer any further questions.

Screen Shot 2021-08-10 at 6.19.08 PM.png

Dynamic Formula Categorization hopex1229.yxzp

Christina_H

Here's an option using only the standard tools in case you don't want to use CReW macros.

Dynamic categorisation.yxmd

Christina_H

Here's an option using only the standard tools in case you don't want to use CReW macros

Dynamic categorisation.yxmd

Christina_H

This can also be done without CReW macros in case you don't want to use them.

(Apologies if this appears more than once, I've tried to post it a couple of times and it hasn't appeared)

Dynamic categorisation.yxmd

atcodedog05

Hi @hopex1229

Just adding to @clmc9601 solution. You can use pre exitsing dynamic replace tool inplace of CREW dynamic formula.

Workflow:

Hope this helps : )

Dynamic Formula Categorization hopex1229.yxmd

hopex1229

Thank you all! Was able to figure this out using the replies above//

atcodedog05

Hi @hopex1229

My solution is just a variation of @clmc9601 solution. She mainly deserves the solution mark 😅

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703