@richgalloway
basically I want to join two lookups and combine the fields from both by matching on a user field
lookup1 has fields user, ip, mac
lookup2 has fields user, workstation, guid, sid
I want to match the user field and then create a new lookup as below:
lookup with fields user, ip, mac, workstation, guid, sid.
I can join these by using |eval matchfield user but when I do this I lose 19 results from lookup1 as there is no user match in lookup2
lookup1 has 269 users
lookup2 has 250 users (missing 19 users)
I need to create the new lookup but also keep the 19 users that were not matched.
hope that makes sense
... View more