Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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