I am having trouble comparing the columns age and expectedAge, where the column expectedAge is a result of a lookup table. I tried the comparison with "where" as well as "search" clauses. Neither of them worked. I just simply want to select the rows where age > expectedAge. Expected behaviour : Return rows where the above mentioned condition is met. Actual behaviour : Returns nothing. | eval age=bla..bla..bla
| lookup "expected_age_lookup" dummy_s as s OUTPUT expected_age
| fillnull value=777 expected_age
| rename expected_age as expectedAge
| search age > expectedAge
| convert ctime(dummy_Time)
| table age,s,dummy_Time,expectedAge If I remove the lines following (and including) the where/search clause, I see the results of the lookup. How can I achieve this correctly ?
... View more