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!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...