sort columns

[Divyajyothi7]

Hi

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

input:

RecordID

od_z_ritm

od_z_qna

od_z_aitm

z_qna

z_qna2

z_qna3

z_qna4

z_qna5

z_aitm

z_aitm2

z_aitm3

z_aitm4

z_aitm5

z_aitm

z_qna

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

expected output: 

RecordID

old_z_ritm

od_z_aitm

od_z_qna

z_aitm

z_qna

z_aitm2

z_qna2

z_aitm3

z_qna3

z_aitm4

z_qna4

z_aitm5

z_qna5

[RSreeSurya]

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 · Accepted solution]

Hi Divya Jyothi,

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