Determine if 3 fields don't match

walkerj7

I have 3 fields that are joined from 3 different data sets that contain the same type of data.  I need to identify any rows that don't match.  Also, there are some rows that have blanks/nulls so these would automatically give a false flag, and I would need to determine if the other two populated fields don't match.  See an example below where the bold rows are the ones I need to flag:

Field 1	Field 2	Field 3
ABC	ABC	ABC
	ABC	ABC
ABC	DEF	ABC
DEF	DEF	DEF
	ABC	DEF

Qiu

@walkerj7 
We can first filter out the Empty or Null valve after a Transpose then count the distinct vale for each row.

If the distinct count is 1 then meaning all 3 fields are equal.

1021-walkerj7.yxmd