lookup multiple inputs

[chvnc]

Hi,

one field has two values while use multiple input field within a lookup command and not getting the output.
The lookuptable looks like this:

env id file

eservices 123 abc123
xyz 456 abc456

I tried it like this, but it didn't work:

passing the env and id values in query and then
| lookup lookup.csv env,id OUTPUT file

if I pass only env=xyz its working but if two values are passed its not working.

[sundareshr]

Try this

.... | eval env_id=env." ".id | lookup "env id" AS env_id OUTPUT file