https://community.splunk.com/t5/Knowledge-Management/Case-in-lookup-values/m-p/449373#M6200 <P>Under Lookup Definitions / / Advanced Option --&gt; Uncheck 'Case sensitive match'</P> Wed, 08 May 2019 20:05:10 GMT huibertsp 2019-05-08T20:05:10Z https://community.splunk.com/t5/Knowledge-Management/Case-in-lookup-values/m-p/449372#M6199 <P>I am trying a lookup search and I get some empty spaces (not all). My data has mixed case values between 'host' column from my logs and 'name' column from my Lookups. Is there a way to make the match case-insensitive or do like a UPPER() or LOWER() on both matching sides?</P> <P>index=iis <BR /> | lookup ListOf_servers name as host OUTPUT description, comment <BR /> | table host description, comment <BR /> | dedup host</P> Wed, 08 May 2019 16:27:00 GMT https://community.splunk.com/t5/Knowledge-Management/Case-in-lookup-values/m-p/449372#M6199 huibertsp 2019-05-08T16:27:00Z https://community.splunk.com/t5/Knowledge-Management/Case-in-lookup-values/m-p/449373#M6200 <P>Under Lookup Definitions / / Advanced Option --&gt; Uncheck 'Case sensitive match'</P> Wed, 08 May 2019 20:05:10 GMT https://community.splunk.com/t5/Knowledge-Management/Case-in-lookup-values/m-p/449373#M6200 huibertsp 2019-05-08T20:05:10Z