I added a MM_ to the month field (added 01_ to January, etc.) so when I used the crosstab tool, it sorted in the right month order by month. Is there a way to remove the 1st 3 characters now that I have the months in the right order
Solved! Go to Solution.
@timothysmith_NYFRB here is one way to do it with a Dynamic Rename tool.
Regex_Replace([_CurrentField_],"\d{2}_","")
Thank you very much, I used the dynamic rename tool, but thought I had to use 12 tools, the Regex_Replace really made it simple with 1 tool
@timothysmith_NYFRB Glad to help! When able, please mark it as a solution to help out future Alteryx users in their search. :)