Splunk Search

Matching data across columns

New Member

Hi,
I'm trying to work out how I can display values from a column based on a unique number appearing in another column. Here's what I'm working with:

Col1    Col2
Item_0  Monkey
Item_1  Tiger
Item_2  Gorilla
Type_0  1
Type_1  1
Type_2  0

For example, Item0 and Type0 need to line up, resulting in Monkey 1, Item2 and Type2 is Gorilla 0 etc.

Thanks in advance, Splunk ninjas!

Tags (3)
0 Karma

Esteemed Legend

Like this:

| makeresults 
| eval _raw="Col1,Col2
Item_0,Monkey
Item_1,Tiger
Item_2,Gorilla
Type_0,1
Type_1,1
Type_2,0" 
| multikv forceheader=1 
| table Col1 Col2

| rename COMMENT AS "Everything above generates sample event data; everything below is your solution"

| rex field=Col1 "_(?<which>\d+)$"
| stats values(*) AS * BY which
| foreach Item Type [ eval <<FIELD>> = mvindex(Col2, mvfind(Col1, "<<FIELD>>*")) ]
| table which Type Item
0 Karma

Ultra Champion
| makeresults 
| eval _raw="Col1,Col2
Item_0,Monkey
Item_1,Tiger
Item_2 ,Gorilla
Type_0,1
Type_1,1
Type_2,0"
| multikv forceheader=1
| table Col1 Col2
| rex field=Col1 "(?<digit>\d)"
| stats values(*) as * by digit
| fields - digit
0 Karma