Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Splunk Search
×
Are you a member of the Splunk Community?
Sign in or Register with your Splunk account to get your questions answered, access valuable resources and connect with experts!
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Find Answers
- :
- Using Splunk
- :
- Splunk Search
- :
- Re: How to bring non matching values into the same...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ayush1906
Path Finder
11-01-2019
07:15 AM
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.
1 Solution
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
woodcock
Esteemed Legend
11-04-2019
09:45 PM
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
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
woodcock
Esteemed Legend
11-04-2019
09:45 PM
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
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ayush1906
Path Finder
11-04-2019
10:16 PM
thanks 🙂
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
to4kawa
Ultra Champion
11-01-2019
08:50 AM
your search
|table Name Attendance Class
|join Name type=outer [|inputlookup your_lookup]
|eval Attendance=if(Attendance!="",Attendance,"absent")
Hi, how about this?
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!
Take Action Automatically on Splunk Alerts with Red Hat Ansible Automation Platform
Are you ready to revolutionize your IT operations? As digital transformation accelerates, the demand for ...
Calling All Security Pros: Ready to Race Through Boston?
Hey Splunkers,
.conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...
Beyond Detection: How Splunk and Cisco Integrated Security Platforms Transform ...
Financial services organizations face an impossible equation: maintain 99.9% uptime for mission-critical ...
