topic Re: Compare two field values and get matching third value from table in Splunk Search

Compare two field values and get matching third value from table

ckunath — Mon, 10 Apr 2017 06:31:03 GMT

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!

lguinn2 — Mon, 10 Apr 2017 07:06:16 GMT

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 — Mon, 10 Apr 2017 07:14:25 GMT

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