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
I just solved it a while back. I had to add double quotes to the extra column values added.That worked.
Thanks!
I just solved it a while back. I had to add double quotes to the extra column values added.That worked.
Thanks!
You should click Accept
on your answer to close the question.
@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?