Sort based off colored columns in excel file?

[laurennewton]

Hi all, I'm currently working on the output of a workflow that requires color coding based off of date. I have figured that portion out but am now trying to sort the final output to show all red dates first, then yellow and lastly the white cells.

The dates are colored red if they are before the current date, colored yellow if they are within 30 days of the current date and white if they do not fall into either of these categories. I created the color rules for this successfully in the table tool in the date field column rules. Now I just need to figure out how to sort it so the red shows first, then yellow then white. Is this possible in Alteryx?

I've attached an example of my workflow.

[Qiu]

@laurennewton 
How about we assign an order number for each color then remove it from the output.

[jrgo · Accepted solution]

Hi @laurennewton 

You should be able to just sort your data on the "Release Date" (ascending) before it goes into the "Table" tool. I had to parse out the date field as it looks like the sample you pasted in the Text input tool resulted in "Release Date" field not in a proper DATE format.

[laurennewton]

Wow such an easy fix, thank you!