Compare two fields return data value

sk1800

Hi,

I'm a bit confused/stuck how to do this.

I have 2 fields from individual datasets. Field 2 can contain 0's along with nulls and regular integers while Field 1 only has null and non 0 values

Field 1          Field 2

null                null

1                    1

                      0

I want to return a TRUE message if there is a value in one field and not the other. For example

field1   field 2   value

8231    21389   TRUE

 null          0       FALSE

21893     null     TRUE

1               0       TRUE

null          null     FALSE

Thank you.

atcodedog05

Hi @sk1800 

Here is how you can do it.

Workflow:

Hope this helps : )

Compare.yxmd