When I want to update lookup using search like below, it updates lookup table even if there is no results, but I want to avoid it.
~ | outputlookup sample.csv
So, I was thinking that I can do it by using macro, and configured like below, but it didn't work.
Validation Error Message
result is null !
For example, in the sample search shown below, the field "result" is passed to the macro and the field is null, so I thought that I would get an error, but I did not get an error.
| makeresults count=1
How can I do it? If someone know about it, please tell me.
Thank you for answer.
But in that Answers, problem wasn't solved.
I do not know the reason after all, but it ended with the conclusion that
isnum() function did not work well.
I wonder how some functions such as
isnum () and
isnotnull () do not work well with macros.