Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

sorting output columns by alphabetical order

187
8 - Asteroid

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

 

 

 

 

1 REPLY 1
binu_acs
21 - Polaris

@187 One way of doing this

image.png

Labels
Top Solution Authors