Sorting from url issue

Question

I have a workflow that has worked wonderful for the time I've been using it. Except now. It scrapes a listing of url links from a directory, sorts by descending and then I use select to grab the first entry. Which should be the most recent one.

Though now it is putting January on the bottom of the list instead and keeping December 31 as its most recent. Starting from December (down) all the dates align perfectly until I get to the end of the data (90 days worth).

These are the examples of the childurl pull after sort by descending:

Bottom of the sort, containing the recent files I want to pull into Alteryx

Bottom of the sort

Where the sort considers the "top" of the descending.

Top of the sort

Fixes? Suggestions?

kelsey_kincaid · Accepted Answer

Hi @GoldenDesign04 ,

My guess is that since you're sorting on strings, the sort tool cannot recognize that January 2020 is after December 2019. It will only sort the numbers as they are presented without factoring in any date specific logic. What you could do is parse out the date from your string, then sort on that. You could either use text to columns and delimit on the underscore, or use RegEx to parse that out.