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.
I have a question is there an easy way or an add-on to Alteryx that will automatically convert the data format 2017-01-01 into 2017 Q1 ? How can I figure this out without a bunch of weird codes? Thanks.
No add ons or instant tools for this, that I know of.
A couple options, the one I like best (and use myself) is a macro. Code it once, and you never have to again.
Personally, I'd make it one not-terribly-long if/then statement. I prefer boolean if/then, but you can use traditional if/then/else or if/then/elseif if you like.
Here's my formula:
IIF(Substring([incomingdate],5,2) IN ('01','02','03'),'1', IIF(Substring([incomingdate],5,2) IN ('04','05','06'),'2', IIF(Substring([incomingdate],5,2) IN ('07','08','09'),'3', IIF(Substring([incomingdate],5,2) IN ('10','11','12'),'4', Null()
You make that into a macro and it just becomes another tool.