compare two fields - return 'match' or 'nomatch'

jomamma1 — Sat, 16 Nov 2024 04:50:47 GMT

I have two fields that I loaded in

HostStatusPrevious

HostStatusCurrent

The fields are loaded in a table such as:

HWStatus as HWStatusCurrent,

Oct:
LOAD AssetID_Value as matchme,
HostName_Value as HostnamePrev,
HWStatus_Value as HWStatusPrev

from excelfile1;

Jan:
Outer join (Oct)
LOAD AssetID as matchme,
HostName as HostnameCurrent,
HWStatus as HWStatusCurrent,

from excelfile2;

How do i compare hwstatusprev and hwstatuscurrent and return a 'match' or 'nomatch' in a howstatusstate field.

thx.

Re: compare two fields - return 'match' or 'nomatch'

bgerchikov — Fri, 04 Jan 2019 18:57:07 GMT

Quite simple:

Data:
Load *,
If(HWStatusCurrent <> HWStatusPrev and HostnameCurrent = HostnamePrev, 'match','nomatch') as MatchFlag
Resident
Oct
;
Drop table Oct;