Compare two columns with different values simultaneously

[hegdepavithra10]

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?

[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 😀👍

[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

[atcodedog05 · Accepted solution]

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 😀👍