I'm working on a kvstore that has multiple interesting columns with which i might determine to enrich an event.
For example, | lookup kvstore a as a
which of course works fine if a exists in the kvstore. However, if this doesn't match to a record,
i'd like to | lookup kvstore b as bif the first one fails, and on and on onto c and d and so on until i find a matching lookup and output that row.
I've tried this by simply putting several lookups after each other as such:
| lookup a as a
| lookup b as b
| lookup c as c
but this breaks, because if a matches I'm happy, i dont need the other lookups, however if adoesn't match, i still need to progress with further lookups..