Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

To many IF conditions in excel to Alteryx

sriniprad08
11 - Bolide

Hi Team,

Hope you are well.

I need help. I have this excel function which i need to replicate into alteryx. Can you please help?

thanks

IF(B3="BELOW THRESHOLD STABLE",0,IF(B3="ABOVE THRESHOLD STABLE",1,IF(B3="ABOVE THRESHOLD FLAG",2,0)))+IF(C3="BELOW THRESHOLD STABLE",0,IF(C3="ABOVE THRESHOLD STABLE",1,IF(C3="ABOVE THRESHOLD FLAG",2,0)))+IF(D3="BELOW THRESHOLD STABLE",0,IF(D3="ABOVE THRESHOLD STABLE",1,IF(D3="ABOVE THRESHOLD FLAG",2,0)))+IF(E3="BELOW THRESHOLD STABLE",0,IF(E3="ABOVE THRESHOLD STABLE",1,IF(E3="ABOVE THRESHOLD FLAG",2,0)))+IF(F3="BELOW THRESHOLD STABLE",0,IF(F3="ABOVE THRESHOLD STABLE",1,IF(F3="ABOVE THRESHOLD FLAG",2,0)))+IF(G3="BELOW THRESHOLD STABLE",0,IF(G3="ABOVE THRESHOLD STABLE",1,IF(G3="ABOVE THRESHOLD FLAG",2,0)))+IF(H3="BELOW THRESHOLD STABLE",0,IF(H3="ABOVE THRESHOLD STABLE",1,IF(H3="ABOVE THRESHOLD FLAG",2,0)))

 

I would like to create the column I ,"Weighted Score" in the below excel file.

Please find attached,

 

Thanks,

17 REPLIES 17
atcodedog05
22 - Nova
22 - Nova

Hi @sriniprad08 

 

Click on a column in table tool.

sriniprad08
11 - Bolide

Hi @atcodedog05 ,

It's showing just 

sriniprad08_0-1634124363318.png

thanks,

Sri

atcodedog05
22 - Nova
22 - Nova

Hi @sriniprad08 

 

Click on KPI 1 it should get selected like below. Then you can click on create or edit.

 

atcodedog05_0-1634124531052.png

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Hi @sriniprad08 

 

This interactive lesson would be helpful.

https://community.alteryx.com/t5/Interactive-Lessons/Building-Tables/ta-p/553696

 

Hope this helps : )

sriniprad08
11 - Bolide

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

sriniprad08_0-1634124888595.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @sriniprad08 

 

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
13 - Pulsar

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

Maskell_Rascal_0-1634133282083.png

 

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. 

Maskell_Rascal_1-1634133366110.png

 

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. 

Maskell_Rascal_2-1634134958651.png

 

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

Maskell_Rascal_3-1634135040841.png

 

Output after running workflow:

Maskell_Rascal_4-1634135066740.png

 

Cheers!

Phil

 

sriniprad08
11 - Bolide

Hi @Maskell_Rascal ,

Awesome. Thank you so much. 

 

Cheers,

Labels
Top Solution Authors