Lookup file data in a search string

[rashi83]

Hi ,

I have following search string , where Username field is extracted using rex command . Now I want to use a lookup file which has field "user" which matches the extracted "Username" field . How can I use lookup commands to match this and get more interested fileds like Office in the search string
index="x"
| rex field=_raw "(?:Users%5C)(?(.*))(?:%5C(local|input))"

[vnravikumar]

Hi

Try like

...your query |lookup <<lookupname>> user AS Username OUTPUT Office