Splunk Search

How to bring non matching values into the same column

ayush1906
Path Finder

Hi ,

My current index when done table shows:

Name| Attendance | Class
abc | Present | 2A
efg | Present | 2A

And my lookup has the following details: (I can edit the values in this lookup)
Name Attendance Class
abc

efg
hig

And my expected output is
Name| Attendance | Class
abc | Present | 2A
efg | Present | 2A
hig | absent

When I am trying to do append, it actually brings names twice. Any advice?
This is just a sample representation, I have other columns as well.

0 Karma
1 Solution

woodcock
Esteemed Legend

DO NOT USE join; try this:

Your first search here:
| inputlookup append=t YourLookupNameHere.csv
| stats first(Attendance) AS Attendance Values(Class) AS Class BY Name
| fillnull value="Absent" Attendance

View solution in original post

0 Karma

woodcock
Esteemed Legend

DO NOT USE join; try this:

Your first search here:
| inputlookup append=t YourLookupNameHere.csv
| stats first(Attendance) AS Attendance Values(Class) AS Class BY Name
| fillnull value="Absent" Attendance
0 Karma

ayush1906
Path Finder

thanks 🙂

0 Karma

to4kawa
Ultra Champion
your search
|table Name Attendance Class
|join Name type=outer [|inputlookup your_lookup]
|eval Attendance=if(Attendance!="",Attendance,"absent")

Hi, how about this?

0 Karma
Get Updates on the Splunk Community!

Transforming Financial Data into Fraud Intelligence

Every day, banks and financial companies handle millions of transactions, logins, and customer interactions ...

How to send events & findings from AWS to Splunk using Amazon EventBridge

Amazon EventBridge is a serverless service that uses events to connect application components together, making ...

Exciting News: The AppDynamics Community Joins Splunk!

Hello Splunkers,   I’d like to introduce myself—I’m Ryan, the former AppDynamics Community Manager, and I’m ...