Sort field names - Numeric prefix

[Krish]

I have field names like

01:Name ,04:Type ,10:Status,12:IsReady ,100:IsTested

When I use select tool - Sort option It sorts as follows

1:Name

4:Type

10:status

100:IsTested

12:IsReady

But I need to sort based on numeric value prefix

1,4,10,12,100

Thanks in advance.

Krish

[MarqueeCrew]

You could text to columns with : as the delimiter and only output 1 field. Select the field and change the type to int16. Now you can sort on that field.

Cheers,
Mark

[patrick_digan]

@Krish You could also try a modified version of @AdamR_AYX's field sort macro from his Crew Macros. I've attached the macro. You would want to check the Use dictionary sort box (This was the feature that I added).

[Krish]

I will try both the options and update.

Thanks,

Krish

[Krish]

https://community.alteryx.com/t5/Data-Preparation-Blending/How-do-I-change-the-position-of-the-colum... This link also solves 

[Krish · Accepted solution]

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