In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

sort columns

Divyajyothi7
8 - Asteroid

Hi

I have following header which are scrambled , i need my headers in sort order

 

input:

 

RecordIDod_z_ritmod_z_qnaod_z_aitmz_qnaz_qna2z_qna3z_qna4z_qna5z_aitmz_aitm2z_aitm3z_aitm4z_aitm5

 

z_aitmz_qna

 top 2 column names can be added till 15 , z_aitm15,z_qna15 i would like to dynamically sort those columns

 

expected output: 

RecordIDold_z_ritmod_z_aitmod_z_qnaz_aitmz_qnaz_aitm2z_qna2z_aitm3z_qna3z_aitm4z_qna4z_aitm5z_qna5
2 REPLIES 2
RSreeSurya
9 - Comet

Hi 

 

Are you willing to give columns list as input - the order in which these should be sorted (Can be given as text/excel and can be changed in future, when changes are required) Or are you looking for solution which automatically sorts without the columns order as manual input? 

RSreeSurya
9 - Comet

Hi Divya Jyothi,

 

I have implemented taking list of columns order as input. Attaching the sample workflow, please have a look.

 

 

 

 

Labels
Top Solution Authors