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 CUSTOMERKEY moves | transaction CUSTOMERKEY mvlist=t | makemv delim="," moves )