How to compare between two inputlookup to get unmatched host w.r.t to lookup1?

[Ash17]

We want to compare 2 inputlookup files. Lets say we have fields in lookup 1-
host- abc, bcd, def, xyz,
& lookup 2
host- bcd, xyz
required result = abc, def
simply we want to show the count of the host missing in lookup 1 when compared to lookup 2.

we have already tried
| inputlookup lookup2 |join type=left host [inputlookup lookup1 |eval check="match" ] |search NOT check=*

[ITWhisperer]

| inputlookup lookup2 
| eval lookup="lookup2"
| append [| inputlookup lookup1 ]
| stats count values(lookup) as lookup by host
| where count=1 AND lookup="lookup2"
| stats count

[Ash17]

Thanks for the effort, but it not giving the correct result

[ITWhisperer]

In what way is it wrong?

[Ash17]

I am getting host on both the lookup files from this search. And we want only missing host from lookup1when it is compared with 2nd lookup

[ITWhisperer]

The hosts have to match completely - do you perhaps have some trailing or leading spaces for example which are in one lookup but not in the other?

[Ash17]

yes they are matching completely.