Splunk Search

Compare two field values and get matching third value from table

ckunath
Communicator

Hello,

i'm trying to do a search and then compare my result with a table from a .csv file (contains a table with ids and text for each id).
My search:

index=foo eventid=200 | append [|inputlookup ids.csv] | table eventid id text

This gets me a table like this:

eventid | id | text
10      |    |
        | 1  | text1
        | 2  | text2

[...]

How can I change my search to make the table look like this?

id | text
10 | text10

Thanks in advance!

Tags (4)
0 Karma
1 Solution

lguinn2
Legend

If you want to get a matching value from a table, you need to use the lookup command.

 index=foo eventid=200 
| lookup ids.csv eventid as id OUTPUT id text
| table eventid id text

View solution in original post

lguinn2
Legend

If you want to get a matching value from a table, you need to use the lookup command.

 index=foo eventid=200 
| lookup ids.csv eventid as id OUTPUT id text
| table eventid id text

ckunath
Communicator

Thanks a lot for the quick response! Works as intended.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...