Dashboards & Visualizations

How to match a string in a table with a field from another csv file column?

KalebeRS
Explorer

Hello.

i have a search with different files. In my table I have a field EDZ_000. In another csv file, I have a list with this field EDZ_000 to EDZ_XXX. Need to match this fields to get another column. How do I do that?

Unfortunately, i can't show the source code.

Labels (2)
0 Karma

yeahnah
Motivator

Hi @KalebeRS 

Here's a link to the lookup command documentation, which based on the limited information provided should be what you need.

https://docs.splunk.com/Documentation/Splunk/9.0.5/SearchReference/Lookup

I'm assuming your table and the csv file have a matching field column to link the data.

Get Updates on the Splunk Community!

Modern way of developing distributed application using OTel

Recently, I had the opportunity to work on a complex microservice using Spring boot and Quarkus to develop a ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had 3 releases of new security content via the Enterprise Security ...

Archived Metrics Now Available for APAC and EMEA realms

We’re excited to announce the launch of Archived Metrics in Splunk Infrastructure Monitoring for our customers ...