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!

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...

Splunkbase | Splunk Dashboard Examples App for SimpleXML End of Life

The Splunk Dashboard Examples App for SimpleXML will reach end of support on Dec 19, 2024, after which no new ...

Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...