Tricky rules-based addition of a column

[hopex1229]

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

[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.

[Christina_H]

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

[Christina_H]

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

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

[atcodedog05 · Accepted solution]

Hi @hopex1229 

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

Workflow:

Hope this helps : )

[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 😅