Case:
1. Lookup table (ex below)
name, day
example1,1
example2,2
2. Search that joins the lookup table and adds the day field
eventtype=Eventtype1 | lookup CustomLookupTable name | table name, code
All of this works fine and I get results shows the name and code.
My issue lies in the fact that sometimes I will have names that do not appear in the search, but I want them to display regardless. Example below:
CustomLookupTable
name, day
example1,1
example2,2
example3, 3
example4, 4
Search Results
example1
example2
example4
Table Output
example1 1
example2 2
example4 4
What I would like to see
example1 1
example2 2
example3 3
example4 4
I have simplified everything in the search to make it easier to write, but there are other fields being populated in the table from the search. As you can see in what i would like to see it is going to show all results from the lookup table regardless if it finds it in the table or not and then will add the fields I want from the search.
I hope all this makes sense. Thank you in advance.
... View more