Compare two columns with different values simultaneously

Hi,

I am trying to perform different operations of two columns and the result must be stored under the same column "Results".

I have added Record ID for this data.

For the first two rows i have done the following :

if [recordid] = 1 and [column1]=[column2] then "Match"

elseif [recordid]=2 and [column1]=[column2] then "Match"

elseif [recordid] in (1,2) then "Not Match"

else null() end if

I wanted to write separate formula for the other two operations and store the result in same column. But everything has gone null instead

Could somebody suggest a solution to this?

Data Investigation

Accepted answers

atcodedog05

Hi @hegdepavithra10

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

match.yxmd

All comments

atcodedog05

Hi @hegdepavithra10

There was datatype mismatch. Try this formula.

if [recordid] = 1 
and ToString([column1])=ToString([column2]) 
then "Match"

elseif [recordid]=2 and ToString([column1])=ToString([column2]) 
then "Match"

elseif [recordid] in (1,2) then "Not Match"

else null() endif

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

match.yxmd

hegdepavithra10

Along with 1 and 2 row , i am looking for 3 and 4 th row calculation to be done as well. And the results must be in the same column.

3rd row to check if the value in column 1 is greater than 0.1% if yes then the comment in column "Results" must be "greater than 0.1%"

and 4th row must check if the difference between column 1 and 2 is greater than 2

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703