community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How to sort 1.1.1.1 format?

Atom

Let say I have

 

1.1.2
1.1.2.10
1.1.2.1
1.1.2.11
1.1.2.2
1.1.2.3
1.1.2.4
1.1.2.5
1.1.2.6
1.1.2.7
1.1.3
1.1.4
1.1.4.1

 

How can I sort the output result like this?

 

1.1.2
1.1.2.1
1.1.2.2
1.1.2.3
1.1.2.4
1.1.2.5
1.1.2.6
1.1.2.7
1.1.2.10
1.1.2.11
1.1.3
1.1.4
1.1.4.1

Atom

Hi, can you try this?

Atom

Thx for the solution, But if the format is dynamic and may get more than ten dot, is there a smart way to sort them?

Highlighted
Alteryx Certified Partner

Hey @EricYiu 

 

This might work for you...

 

Essentially you need to split out the value into rows, pad the out with zero's (i did 5 but you can choose as many as you want) then concatenate it all back together, which will then give you the ability to sort.

 

Sort thing.PNG

 

Neil

Atom

HI Lord, It works... Much thx for the solution.

Labels