Eval Lookup

[Ning]

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! 

[kamlesh_vaghela · Accepted solution]

@Ning 

You can try something like.

| lookup lookupA myField output opA
| lookup lookupB myField output opB
| eval opField= if(isnull(opA),opB,opA)