Here is the test_lookup.cvs I'm using: c1 c2 c3 c4 c5 r1 1 2 3 4 r2 5 6 7 8 r3 9 10 11 12 r4 13 14 15 16 This works: | inputlookup test_lookup.csv
| eval input="r1,r2"
| makemv delim="," input
| eval input_rule=if(c1=input,"1","0")
| where input_rule=1
| format
| eval search="\"".search."\"" Returns: "( ( c1="r1" AND c2="1" AND c3="2" AND c4="3" AND c5="4" AND ( input="r1" OR input="r2" ) AND input_rule="1" ) OR ( c1="r2" AND c2="5" AND c3="6" AND c4="7" AND c5="8" AND ( input="r1" OR input="r2" ) AND input_rule="1" ) )" So I created test_macro(1) inputlookup test_lookup.csv
| eval input="$rows$"
| makemv delim="," input
| eval input_rule=if(c1=input,"1","0")
| where input_rule=1
| format
| eval search="\"".search."\"" Run this: | makeresults
| eval rows="r1,r3"
| eval score=
[|`test_macro(rows)`] Using the macro the results are: NOT () I have tried everything I can think of! Pulling my hair out at this point. Thanks.
... View more