Checking conditions of two fields

Hi

I'm trying to do a very simple comparison but couldn't think of an efficient tool to do it.

As an example, if [Items] = WEATHER01, [value] <= 25, then [Conditions agree] = yes.

Below is sample output expected.

Items	Value	Conditions agree?
WEATHER01	20	Yes

Thank you in advance

Data Investigation

Accepted answers

A formula tool with an if statement will get this done. See below and attached

New Workflow3.yxmd

Hi @alkafalhas,

I have a feeling that you have more condition for different items:

The output:

All comments

A formula tool with an if statement will get this done. See below and attached

New Workflow3.yxmd

Hi @alkafalhas,

I have a feeling that you have more condition for different items:

The output:

What if i have a multiple items? should I add same formula by using the (+) button in the formula tools? or you have better ideas?

Hi @alkafalhas,

The mapping table is always easier to maintain in a long run. So if possible I would almost always suggest using mapping tables instead of the formula tool.

Thank you for helping so far.

If I have a multiple items with different conditions, how can i address it?

Example below:

Items	Value	Conditions	Output
WEATHER01	20	Yes, if value<=20	yes
WEATHER02	20	Yes, if value<=10	No
WEATHER03	40	Yes, if value<=40	Yes

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703