Hi, I saw similar questions about this. I've tried the suggestions and have been unsuccessful. Please excuse the redundant question, but I thought if I post a question that is very customized to my issue, it may help...
Ok.... I'm the newest of newbies! I've been messing with this issue for hours and still have no solution. I would like to control a search using criteria in a csv file. I have a single column spreadsheet with two or three values in as many rows. I save out of excel as a csv file.
from there, I load in the csv file under MANAGER>LOOKUPS>LOOKUP TABLE FILES. for illustration, I name this file testlookup.csv
from there, I define the lookup under MANAGER>LOOKUPS>LOOKUP DEFINITIONS. I use a FILE BASED definition and call the lookup testlookup and reference the testlookup.csv file previously loaded.
then, when I run the search:
host="myhost" (limiting the time)
I get a return of over 500 records
then, if I manually put in the criteria that is in the csv file, that limits my search to 8 records
host="myhost" string1 string2
however, when I attempt to use the lookup, I can not get any results.
host="myhost" | inputlookup testlookup
this search throws an error "Error in 'inputlookup' command: This command must be the first command of a search."
FINALLY, any other combinations that I have tried with LOOKUP, INPUTLOOKUP etc yield either an error or 0 results....
any assistance would be greatly appreciated.
With this exercise, I'm trying to get this to work as an AND function, but would also appreciate any guidance to have the CSV file records perform the OR function as well.
Kos
... View more