topic Re: inputlookup shows no results after adding two more columns to csv in Splunk Search

inputlookup shows no results after adding two more columns to csv

amuralisundaram — Tue, 29 Sep 2020 19:11:31 GMT

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

Re: inputlookup shows no results after adding two more columns to csv

niketn — Sun, 22 Apr 2018 13:00:16 GMT

@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?

Re: inputlookup shows no results after adding two more columns to csv

amuralisundaram — Sun, 22 Apr 2018 13:30:58 GMT

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

Thanks!

Re: inputlookup shows no results after adding two more columns to csv

woodcock — Sun, 22 Apr 2018 16:06:07 GMT

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