Splunk Search

Problem in Lookup

abhayneilam
Contributor

Hi,

I am getting the below message when I am using lookup

my command .... | lookup "Full_CDI.csv" user_sso

Empty csv lookup file (contains only a header) for table 'Full_CDI.csv': C:\Program Files\Splunk\etc\apps\search\lookups\Full_CDI.csv

I have around 5,91,662 Data in my Full_CDI.csv file, but still I am not getting any data as a output , all the fileds are coming blank in the result set in SPLUNK but data is present in the CSV file..

Suggest me any solution for this !!
Thanks in Advance !!

Tags (2)
0 Karma

SplunkFu
Path Finder

What does the output look like if you run:

| inputlookup "Full_CDI.csv"

Make sure the csv is in UTF-8 and not ANSI, and is not just a poorly formatted excel document.

Hope this helps.

0 Karma

abhayneilam
Contributor

when I am seperately doing the below command :

|inputlookup "Full_CDI.csv"

then all the data I am getting as my result set

Please suggest !!

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...