Get Alteryx Files From Directory in Order

[RussellMichaelson]

Hello all, 

I have some unfortunate file names that are giving me trouble. I need to import all the pictures from a folder I have. They are saved in the order that I want and all within 1 second. 

The issue is that when I import them using the directory tool, it puts them slightly out of order based on number:

So I need it to import them in order (ex. 1.1, 1.2, 1.3) not 1.1, 1.10, 1.11, 1.2. They are all saved within the same second so I cant just sort by CreationTime descending. 

Any thoughts?

[Luke_C · Accepted solution]

You should be able to parse out the numbers into a new column and then sort based on that column. If you have a sample file name we can help figure out the best formula.

[RussellMichaelson · Accepted solution]

It was even simpler! Thank you, your idea led me to the solution. 

What I had to do what Sort tool and then sort by filename ascending and check the "Use Dictionary Order" box. 

This allowed it to sort 1, 2, 3 and not 1, 10, 11, 2, 3, etc. 

Thank you!