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.

Sample.xlsx

RolandSchubert

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