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.
Debating whether or not to upgrade to the latest version of Alteryx Designer?
I have one DateTime column with very inconsistent formats.
I have been using two rounds of Regex to make the format consistent like yyyy-MM-dd hh:mm:ss and managed to "fix" it, including the date and time with only 1 digit (by appending a leading 0) etc.
Being a newbie in Alteryx, I was wondering whether there is a more elegant/efficient/cleaner way of achieving the same output?
I suggest the BB Date macro: https://community.alteryx.com/t5/Engine-Works-Blog/Introducing-BB-Date-Date-Parsing-for-the-Rest-of-...
Another option is the OmniBus tools I maintain. They have a .NET based DateTime parser which will guess format for you. You would need to tell culture to identify M/D/Y for D/M/Y
Otherwise, you could construct some complex formula to identify format and DateTime parse to Alteryx format. I would do a sequence of steps in a formula tool with each one like: