Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Match the serial with what???
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;
Can you show the expected output? I could not understand completely.
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',)
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',)
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.