To many IF conditions in excel to Alteryx

Here is my take on it by setting the column rule

Workflow:

Hope this helps : )

weight.yxmd

Maskell_Rascal

@sriniprad08

There is actually a quick workaround to apply this conditional formatting to all fields instead of doing them one at a time.

1. Delete the connection right before the table tool and run the workflow. This will throw an error but that's ok.

2. Click on the table tool and you'll notice that the only available column to apply a rule to is the Dynamic or Unknown Fields. This is what we will be using to apply this rule to everything.

3. Now you can add three different conditional formatting rules using a formula to define the red/yellow/green values. I add a ToString function to the formula to prevent errors with the numeric fields.

4. Now connect your data back to the table tool, and you will see that these rules are applied to each incoming field.

Output after running workflow:

Cheers!

Phil

All comments

You can transpose it, apply the condition and summation it. Like below

Hope this helps : )

weight.yxmd

Christina_H

I've done basically the same as @atcodedog05 but with a lookup table for the values instead of the formula

Weighted score.yxmd

Hi @atcodedog05 ,

Perfect. Thank you so much is it also possible to color the fields like a heat map for e.g

Wherever its Below Threshold then it should be colored Green. etc.

Please let me know

thanks,

Hi @Christina_H ,

Thank you so much 🙂 . Very helpful.

Cheers

Christina_H

@sriniprad08 To get background colors you'll need to use a table tool with column rules, see attached. I've set conditions on the first two columns, they will need adding to the others too.

Weighted score.yxmd

Here is my take on it by setting the column rule

Workflow:

Hope this helps : )

weight.yxmd

Hi @Christina_H ,

Thank you . Amazing. I was about to paste this question. How to set the rule please?

Thanks,

Sri

Hi @atcodedog05 ,

Not sure why its not showing me the option to edit. Please let me know .

thanks

Click on a column in table tool.

Hi @atcodedog05 ,

Please find attached. not sure why i am not getting the Apply to data only option as of yours in my alteryx table.

Also do we need to define rules individually for all the KRI's? like you did for KR1, KR2 etc.. thanks

You have clicked on row rule you need to click on column rule. Refer to the interactive lesson.

@sriniprad08 wrote:
Also do we need to define rules individually for all the KRI's? like you did for KR1, KR2 etc.. thanks

Yes you would need to define for each.

Maskell_Rascal

@sriniprad08

There is actually a quick workaround to apply this conditional formatting to all fields instead of doing them one at a time.

1. Delete the connection right before the table tool and run the workflow. This will throw an error but that's ok.

2. Click on the table tool and you'll notice that the only available column to apply a rule to is the Dynamic or Unknown Fields. This is what we will be using to apply this rule to everything.

4. Now connect your data back to the table tool, and you will see that these rules are applied to each incoming field.

Output after running workflow:

Cheers!

Phil