I would like to combine 2 lookup table outputs to one multivalue field at search time. Table 1 and Table 2 are below are my lookup outputs. Table 3 is an example of my expected output:
LOOKUP TABLE 1 OUTPUT:
src_port, lookup1_output
1, A
2, B
3, C
LOOKUP TABLE 2 OUTPUT:
dest_port, lookup2_output
1, D
2, E
3, F
I'd like to combine lookup1_output and lookup1_output to form one multivalue output:
TABLE 3: EXPECTED COMBINED MULTIVALUE OUTPUT:
src_port, dest_port, combined_output {lookup1_output,lookup2_output}
1, 2 , {A,E}
2, 3 , {B,F}
and so on..
I tried
eval output = mvcombine(lookup1_output,lookup2_output)
but this does not help as search time order of operations is EVAL -> LOOKUP so I can't use an eval with inputs from a lookup.
Thanks in advance
... View more
