I have two fields that I loaded in
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
Jan:Outer join (Oct)LOAD AssetID as matchme,HostName as HostnameCurrent, HWStatus as HWStatusCurrent,
How do i compare hwstatusprev and hwstatuscurrent and return a 'match' or 'nomatch' in a howstatusstate field.
Data:Load *, If(HWStatusCurrent <> HWStatusPrev and HostnameCurrent = HostnamePrev, 'match','nomatch') as MatchFlagResident Oct;Drop table Oct;