If Numbers are Greater or less than

[mmustkee]

Hi Team,

I have below table and I want below criteria to be used for desired output. Kindly Help.

if Fridge <0 and Washing Machine>0 - Then No
if Fridge >=0 and washing Machine>0 and AC=0 Then No
if Fridge >=0 and Washing Machine>0 and AC>0 - Then Yes

Fridge	Ac	Washing Machine	Status Yes/No
1	0	1
1	0	3
1	0	2
1	1	2
1	0	3
1	0	0
1	0	1
1	0	4
1	1	3
1	0	4
1	0	1
1	2	0
1	0	1
1	2	4
1	0	4
1	0	3
1	0	0
1	0	3
1	1	3
(1)	3	2
(2)	4	1
1	1	1
1	2	1
1	2	0
1	4	0
0	5	1
0	6	3
0	7	2

[AngelosPachis]

Hi @mmustkee ,

Would you mind trying this workflow?

The multi-field formula was used to convert the negative values from (1) to -1

Cheers,

Angelos

[Qiu]

@mmustkee 

What will be result for AC=0?

[mmustkee]

Hi,

My Fridge Value is Numeric. Once I apply your workflow and change text to Numeric or all types I am receiving attached error.

Please help.

Thanks,

Mohammad Mustkeem

[mmustkee]

Hi Qiu,

I can see that there is another new column called Fridge1 and the values in my column called 'Fridge' and your column does not match. I have some negative values also and your column does not show that. Can you create workflow without creating extra column. and once I apply to my data set, I do not see the filed which I want to replace with Fridge and FYI  The field which I want to replace with Fridge is Numeric. Once I drop down none of my numeric value is in dropdown.

Please help.

Thanks,

Mohammad Mustkeem

[AngelosPachis · Accepted solution]

Hi @mmustkee ,

Can you try the attached workflow please?

Thanks

Angelos

[mmustkee]

Hi Angelos,

I am using the same formula, provided by you. The only difference is I am using exl file to apply the same. All the three values in my sheet are numeric however if I check your multi formula tool it shows fridge value as text. I have attached xls file as well as error screen shots. kindly help.

Thanks for your help.

  

  

[grazitti_sapna · Accepted solution]

Hi @mmustkee , give this a try when you import the file into alteryx it will directly convert the (1) into -1.

If this helps kindly mark this post as solution.

[AngelosPachis]

Hi @mmustkee ,

The second workflow I have attached does not have a multi-field formula, you should only be able to find a single formula tool with the expression.

Thanks

Angelos

[mmustkee]

Hi Sapna,

It really worked.

Thanks a lot. It took time as my data type was different.