Splunk Search

inputlookup shows no results after adding two more columns to csv

amuralisundaram
Engager

I had 3 columns initially in the csv file. I added two more and added the same in the inputlookup command. But no table is shown.

Previous command: inputlookup Logs.csv|eval error_description_upper= upper(error_description), searchString=upper("$errorLogToken$") | where like(error_description_upper,"%"+searchString+"%")| rename date as "Date", error_description as "Error Description", time as "Time"|table Date, "Error Description", Time

After adding two columns: inputlookup Logs.csv|eval error_description_upper= upper(error_description), searchString=upper("$errorLogToken$") | where like(error_description_upper,"%"+searchString+"%")| rename date as "Date", error_description as "Error Description", time as "Time",application as "Application Impacted", type as "Type" |table Date, "Error Description", Time, "Application Impacted", Type

0 Karma
1 Solution

amuralisundaram
Engager

I just solved it a while back. I had to add double quotes to the extra column values added.That worked.

Thanks!

View solution in original post

0 Karma

amuralisundaram
Engager

I just solved it a while back. I had to add double quotes to the extra column values added.That worked.

Thanks!

0 Karma

woodcock
Esteemed Legend

You should click Accept on your answer to close the question.

niketn
Legend

@amuralisundaram is the inputlookup command alone giving you all the fields?

inputlookup Logs.csv

What is the before and after structure for your lookup file? Can you add some mocked up data for current lookup file? Are you getting any error when you run the command? Have you checked the permission on the lookup file after uploading the new one?

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

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 ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...