I have two tables "order.csv" and "delivery.csv". How can I use lookup command to check the delivery status based on the product?

[Madhan45]

1. delivery.csv contains the fields- key,name,product,price
2. order.csv contains the fields- key,shipdate,location,delivery_status,price

[woodcock]

You can begin a search with a pipe command, but only if that command creates events, which inputlookup does. So a search like this should work:

  | inputlookup delivery.csv | lookup order.csv key OUTPUT delivery_status | where delivery_status="failed"

[HeinzWaescher]

Do you want to have it like this?

 | inputlookup delivery.csv
 | lookup order.csv key OUTPUT delivery_status

[Madhan45]

I want to find out the "name" where delivery_status is "failed".

Before this command do i need to add index=*?

can u give me a exact command?