I have the following query:
..... | transaction CUSTOMER_KEY mvlist=t | makemv delim="," moves
Problem is when it creates the multivalue field from "moves" values it does it in descending order. I need that to be in ascending order.
Sorting the logs before the transaction doesn't seem to help
(....| sort 0 CUSTOMER_KEY moves | transaction CUSTOMER_KEY mvlist=t | makemv delim="," moves )
Thanks
Have you tried making the moves field multi-value before creating the transaction?
... makemv delim="," moves | transaction CUSTOMER_KEY mvlist=t ... | rest of your search