How to Compare two fields and exclude if the values are same?

[Woodpecker]

Hi,

I have two fields: field 1 and field 2

field1        field 2

ABC           AA\ABC

DEF           DD\DEF

GHI            GG\JKL

Now I need to compare both these fields and exlcude if there is a match

So in the above case it should return only
field1         field 2
GHI             GG\JKL

Could someone help me on this, please?

[Woodpecker · Accepted solution]

This solved the issue 

| where '%field2'!='field1'

[ITWhisperer]

| where NOT match(field2,field1)

[Woodpecker]

@ITWhisperer ,
Sorry, but this not working in my case

[ITWhisperer]

Probably because your example does not adequately reflect your actual data e.g. do you have special characters which would disrupt a regex match?

[Woodpecker]

@ITWhisperer yes..