Splunk Search

Left Outer join - only rows from the left table , in splunk

aayushisplunk1
Path Finder

Is it possible to implement LEFT OUTER JOIN where only rows from the left table are fetched (NOT the Common values)?

Consider the example as given below:

Table A:

email@xxx |........
abcd@xxxx |........
efgh@xxxx |........
xyza@xxxx |........

Table B:

email@xxx|........
ijk@xxxx |........
xyza@xxxx |........

Required output table: Table C:

email@xxx |.........
abcd@xxxx |........
efgh@xxxx |........

My Query:

mysearch1
| table email@xxxx, ....
| join type=left email@xxx
[ search mysearch2
| table email@xxxx , ...]
| table email@xxx, ...

alt text

Tags (1)

jitendragupta
Path Finder

Plz check this output, this is as per your requirement:

| makeresults |  eval id="abcd@xxxx" | append  [| makeresults |  eval id="efgh@xxxx"] |  append  [|  eval id="xyza@xxxx"] 
|  table id 
|  join type=outer id![alt text][1]  [ | makeresults |  eval id="ijk@xxxx" | append  [| makeresults |  eval id="xyza@xxxx"]  |  table id ]
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 ...