ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

How do I change the position of the columns?

JohnDoe
8 - Asteroid

How can I change the position of the columns? Some of the columns I have to move come from my input file, some others I create myself with the multi-field and the formula tool, but I have to move quite a few of them around. I haven't been able to find any documentation on this. Any ideas? Thanks

11 REPLIES 11
Krish
8 - Asteroid
Thanks.my bad,after changing input values,i should have reconnect and sort the columns .
It works fine now.
I just altered for my input data,it worked very well.
Thanks again .
KRISH
Krish
8 - Asteroid

Attached sample flow .

somehow I could not pad 0s in string like 1:Key so I used string manipulation to solve this.

 

PadLeft( SubString([_CurrentField_],0,FindString([_CurrentField_],":")),3,"0")+SubString([_CurrentField_],FindString([_CurrentField_],":"),Length([_CurrentField_]))

 

Also used separate dynamic select for - ve values.

 

Thanks,

Krishna

 

Labels
Top Solution Authors