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!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ask a Question

LookUp table show data who matches and who are not matches

abhi144
New Member
‎04-09-2014 01:28 AM

I have a csv file in which two field are ShopNo and ShopId. From search i'm getting ShopNo and ShopIdinDevice so i wanted a lookup table to show like-

ShopNo ShopIdinDevice Shopid

So i can compare for which ShopNo, ShopIdinDevice and ShopId is different. What should be search command for this?
Any suggestion will be appreciated.

Tags (2)
0 Karma
Reply

somesoni2
Revered Legend
‎04-09-2014 06:01 AM

This could be as simple as below:- 

your base search giving ShopNo,ShopIdinDevice | lookup youlookup.csv ShopNo OUTPUT ShopId
0 Karma
Reply
Get Updates on the Splunk Community!

CX Day is Coming!

Customer Experience (CX) Day is on October 7th!! We're so excited to bring back another day full of wonderful ...

Strengthen Your Future: A Look Back at Splunk 10 Innovations and .conf25 Highlights!

The Big One: Splunk 10 is Here!  The moment many of you have been waiting for has arrived! We are thrilled to ...

Now Offering the AI Assistant Usage Dashboard in Cloud Monitoring Console

Today, we’re excited to announce the release of a brand new AI assistant usage dashboard in Cloud Monitoring ...