This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Since the date you are using is classified as a String by Alteryx, you can use a Find Replace to add in the cardinal. You will have to first split your data using a Text to Columns to make sure that it isn't turning the year 2020 to 20th20th or something weird like that. I've attached a workflow that should work.
you could convert the date to a date data type and use DateTimeFormat including the cardinal. To assign the right abbreviation, a condition within a formula can be used. See attached sample workflow. Let me know, if it works for you.
You can do this by using a Regex parse to split the string and then a formula tool to add the cardinal and then put the pieces back together
The formula used here is
if Contains([RegExOut2],"12") Or contains ([Field1],"11") or contains ([Field1],"13") then
elseif EndsWith([RegExOut2], "1") then
elseif EndsWith([RegExOut2], "2") then
elseif EndsWith([RegExOut2], "3") then
The first clause is used to handle the special case of 11, 12, and 13.