If I'm understanding the question correctly, this should do what you're asking for: | inputlookup data.csv | join title type=left [|inputlookup keywords.csv | rename word as title | eval match="yes"] | eval match=if(isnull(match),"no",match) | table title description match Where data.csv contains: description,title "here is a description","title" and keywords.csv contains: word "some" "random" "title" "here" ... View more

Another easy way you could do it is using a modulo operation: | eval Average = if(Average%1>0,round(Average*100,2),Average*100) Edit: Added the *100 so you can get what I believe is the desired result in one eval. ... View more

I believe something like this should work: /home/\w+/[^\.]+\.(?<schema>[^\.]+)\.(?<table>[^\.]+) ... View more