How can I search vlookup data from CSV?

[naujla85]

Hello I have injested CSV data in lookup. The common data is Service_Method in CSV and dt.entity.service_method in Splunk Query. 

index="*dyn*" source="*:*dgf*" dt.entity.service_method=* metricId=builtin:service.keyRequest.count.total | stats avg(value) as "AvgValueCountTotal" count as "Total" by dt.entity.service_method

I am trying to combine this 2 data set in one table. 

[richgalloway]

Use the lookup command to pull data from the CSV by common fields.

ndex="*dyn*" source="*:*dgf*" dt.entity.service_method=* metricId=builtin:service.keyRequest.count.total | stats avg(value) as "AvgValueCountTotal" count as "Total" by dt.entity.service_method
| lookup my lookup.csv Service_Method as dt.entity.service_method