is it possible to define a default value for a lookup command when no matches are present for the given input?
I know that it works for automatic lookups. But how can I achieve it for this:
| lookup table.csv key OUTPUT result
Or do I have to use a workaround with fillnull or eval?
Thanks in advance
That's what I expected, because I already used it for automatic lookups. No idea why my first try didn't work...but now it does 🙂