Get Alteryx Files From Directory in Order

Question

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 Answer

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 Answer

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!