Hi alteryx engineer,
Here is my request, i read the column from the sheet, and i might get lots of currency and i wanna output them in alphabetical order, but there might be new currency added in. I ticked the *Unknown at Select tool, but the new currency is added at last row, not in alphabetical order, how can i solve this out? Actually there might some summarized column at front and rear, here is the some sample
Payment ARS CAD SGD Total
1 222 333 444 555
if there is new currency added , i want the data should be output like that, I can't use append option for the output , so what is the solution?
Payment ARS CAD CNY SGD Total
1 222 333 44 555 666
@187 One way of doing this
