Need help sorting data with condition

[gelvira]

Hello everyone, 

I can't figure out how to sort this data.

I can do it on SQL but can't figure out how to add conditions while sorting.   [sequence like ( sequence || '.' || '%')]

My data look like:

ID	Sequence	APP
1	1.1.1.10	22
1	1.1.1	22
1	1.1.1.10.1	20
1	1.1.1.1	20
1	1.1.1.10.1.1	20
1	1.1.1.1.1	20

I want something like this: 

ID	Sequence	APP
1	1.1.1	22
1	1.1.1.1	20
1	1.1.1.1.1	20
1	1.1.1.10	22
1	1.1.1.10.1	20
1	1.1.1.10.1.1	20

I would appreciate any help in this regard. 

Thanks!

[michelle_mathews · Accepted solution]

@gelvira , uncheck the box 'Use Dictionary Order' and it should satisfy your requirement

[gelvira]

Thanks! I did that and it didn't work initially. 

After closing Alteryx and running it again, it worked.