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.
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