Alteryx Designer Desktop Discussions

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

How do I change the position of the columns?

JohnDoe
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 ANTWORTEN 11
Krish
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
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

 

Beschriftungen