Splunk Search

Can I use lookup instead of join?

LxSenpai
Explorer

Hello guys
So I have a table where there are Index and Role. In another table, there is Index and Description. So what I am trying to output is something like this below:-

Role | Index | Description
1       | a_2 | World says hello back.
          |a_3| Hello 
2      |a_4| WOW

Currently using join the index fields are being joined. But is there a way to do the joining without Join but only lookup?

|mvexpand Indexes
|fields Index2, Indexes, Role

|join type=outer Indexes [ inputlookup index_info_lu | rename Index as Indexes]  << here>>

| stats list(Indexes) as Indexes,list(Description) as Description by Role
0 Karma
1 Solution

somesoni2
Revered Legend

Give this a try

your base search
|mvexpand Indexes
|fields Indexes, Role
| lookup index_info_lu Index as Indexes OUTPUT Description
| stats list(Indexes) as Indexes,list(Description) as Description by Role

View solution in original post

somesoni2
Revered Legend

Give this a try

your base search
|mvexpand Indexes
|fields Indexes, Role
| lookup index_info_lu Index as Indexes OUTPUT Description
| stats list(Indexes) as Indexes,list(Description) as Description by Role

LxSenpai
Explorer

Thanks alot

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...