Hi, I have a single search that produces the following table where fieldA and fieldB are arbitrary strings that may be duplicate. This is an exact representation of each event where each event may have a key "fieldA" or a key "fieldB" but not both but they always have an ID and Timestamp Timestamp ID fieldA fieldB 11115 1 "z" 11245 1 "a" 11378 1 "b" 11768 1 "d" 11879 1 "d" 12550 2 "c" 13580 2 "e" 15703 2 "f" 18690 3 "g" and I need help to transform the data as follows. ID fieldA fieldB 1 "b" "d" 1 "b" "d" 2 "c" "e" 2 "c" "f" 3 "g" Thanks to suggestion below, I have tried `stats latest(fieldA) list(fieldB)` but I would prefer to not have any multivalued fields For every distinct value for "fieldA", the latest record with that value would be kept and any records with that ID occuring before that record would be discard. There is no requirement to have 2 searches. Hope that makes it more clear and easier.
... View more