I have a Lookup Table the returns data from all 32 columns, but many times data that is confirmed good in the assetlist.csv file comes back as "unknown". Here is a snippet of my header in assetlist.csv:
Along with a snippet of the next line under the header:
Something as simple as asking for the "building" or "cabinet" is returned as "unknown". Here is my search string:
and from this search it returns "building 'unknown' count=55129
Any ideas or thoughts behind why some of the data populates but other data doesn't?
I get the same incorrect results when I run this type of search:
PS. When building the Lookup Table using the UI I checked the "automatic lookups" option so I get all the fields, all the time. Here is the first six columns from that part of the installation:
assetlist logical_name AS host OUTPUTNEW building AS building cabinet AS cabinet cabinet_slot AS cabinet_slot customer_facing AS customer_facing deploy_status AS deploystatus
This setup is as generic as possible and nothing tricked out to do anything fancy so I would think it would work "all the time".
asked 04 Apr '12, 09:27
Without more information I think the most likely thing is that your lookup is accidentally configured as a temporal lookup meaning there should be a match but it is trying to get a time dependent match and fails.
Another possibility is that your lookup command is malformed. It looks like you are trying to lookup based on the host field of your data, so the search should be:
Also the name in your example is logicalname and in your search logical_name which is it?
For a better answer please provide a sample event, full line of the lookup table, and the props and transforms entries for the events and the lookup.
answered 21 Aug '12, 13:55