From fieldA thru fieldD are not multivalue before connecting with STATS comamnd. This table is the results from STATS command.
Please suppose fieldA,B are defined by S1, and filedC,D are defined by S2. And these sources can connect by key1 and key2.
The search text is.....
(source = S1) OR (source = S2) | stats values(fieldA) as filedA values(fieldB) as fieldB values(fieldC) as fieldC values(fieldD) as fieldD by key1 key2 | table key1 key2 fieldA fieldB fieldC fieldD. Hope this will help.
... View more