Hi All,
Is it possible to perform Eval then perform lookup ?
If the eval return null then perform lookupA.csv. If eval return notnull, then perform lookupB.csv
thanks!
You can try something like.
| lookup lookupA myField output opA
| lookup lookupB myField output opB
| eval opField= if(isnull(opA),opB,opA)
You can try something like.
| lookup lookupA myField output opA
| lookup lookupB myField output opB
| eval opField= if(isnull(opA),opB,opA)