Compare 3 values in straight table

[Aitelli_805]

I have a  Straight table and in that table, I have multiple dimensions to compare. These comparison are sap serial, device, code. would like to make a column  to show the serial which doesn't match and match and user would be able to look up to select the serial number match ore not match.  Any suggestion would appreciate.

Location	Name	grid	status	sapserial	device	code	Asset
NJ	Isabel	12	installed	3456	9898	3456	121234
NY	Marc	14	installed	78910	7878	78910	145678
NY	Cat	18	installed	2333	2333	2333	111223

[fosuzuki]

Match the serial with what???

[Arslan_Ahmed]

A:
LOAD * INLINE [
Location, Name, grid, status, sapserial, device, code, asset
NJ, Isabel, 12, installed, 3456, 9898, 3456, 121234
NY, Marc, 14, installed, 78910, 7878, 78910, 145678
NY, Cat, 18, installed, 2333, 2333, 2333, 111223
];

B:
Load * , if(sapserial = code , 'True','False') As Match_Field Resident A;

Drop Table A;

[Saravanan_Desingh]

Can you show the expected output? I could not understand completely.

[Aitelli_805]

I'm trying to compare these three data points sapserial, device, code. Another column to show the serial across where they're match or mismatch.  I tried the below formula but when I selected for mismatch still show the serial match. 

=if(sapserial<>device],'Mismatch','Match',)

[Aitelli_805]

I'm trying to compare these three data points sapserial, device, code. Another column to show the serial across where they're match or mismatch.  I tried the below formula but when I selected for mismatch still show the serial match. 

=if(sapserial<>device],'Mismatch','Match',)

[fosuzuki]

In your data load, create a column with this:

if(sapserial=device and device=code,'Match','Mismatch') AS Check

By doing this, you will be able to use this column as a filter.