i have a lookup csv with say 2 columns colA colB sb12121 800 sb879898 1000 ax61565 680 ax7688 909 I need to perform a lookup search that matches like colA which may result in sb12121 800 sb879898 1000 if one of the columns in the logs start with sb (note that it may not be an abs match) I can write a query that absolutely matches with a field in column but I am not sure how to perform a like match. I read something about transforms.conf but not sure where and how to use it. all im trying to do is perform a simple search command, that can do this lookupfor me. do i really need the tranforms.conf file for this ? cant we not do a wildcard search directly in the query ? ... View more