if then else conditions

[Feras95p]

Dear all,

I want your help in that, I have attached an excel sheet with two columns I want to make a workflow to add a new output column with a name of "حالة العميل"  with these conditions if 

Avg+30 ≥ last order > Avg then write in  "حالة العميل"'s column = "منقطع حديثا"    with a blue fill cell

else if

last order ≤ Avg then write in  "حالة العميل"'s column="زبون" with a yellow fill cell

else if

last order>Avg+30 then write in  "حالة العميل"'s column="زبون منقطع"

Any help in that please?

Thanks in advance for your kind support.

[RolandSchubert · Accepted solution]

Hi @Feras95p ,

the conditions translate to Alteryx very straightforward:

IF [Avg] + 30 >= [last order] AND [Last order] > [AVG] THEN
'case 1'

ELSEIF [Last order] <= [Avg] THEN
'case 2'

ELSEIF [Last order] > [Avg] + 30 THEN
'case 3'

ELSE
'not defined'

ENDIF

Simply add a Formula tool, add a new column add insert the formula - I simplified the results a bit.

Hope this is helpful.

Best,

Roland

[Feras95p]

Great! it works thanks a lot, but how I can make each case with a different color cell, it that possible?

[VianneyM]

hi @Feras95p,

attached a workflow that follows your rule. 

I noticed that the last rule has no colour. 

If you want to add one colour more, you can do that within the table tool

Let me know if you have any questions

Best,

Vianney