Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Split the month and year and convert to date format as MM-YYYY

sriku
7 - Meteor
‎07-31-2020 03:15 AM

Hi All,

 

Need help in splitting the month and year and convert to date format as MM-YYYY

 

Name
Jan_19_Actual_Amt_Cal
Feb_19_Actual_Amt_Cal
Mar_19_Actual_Amt_Cal
Apr_19_Actual_Amt_Cal
May_19_Actual_Amt_Cal
Jun_19_Actual_Amt_Cal
Jul_19_Actual_Amt_Cal
Aug_19_Actual_Amt_Cal
Sep_19_Actual_Amt_Cal
Oct_19_Actual_Amt_Cal
Nov_19_Actual_Amt_Cal
Dec_19_Actual_Amt_Cal
Jan_20_Actual_Amt_Cal
Feb_20_Actual_Amt_Cal
Mar_20_Actual_Amt_Cal
Apr_20_Actual_Amt_Cal
May_20_Actual_Amt_Cal
Jun_20_Actual_Amt_Cal

 

Regards,

Sriku

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor
‎07-31-2020 03:22 AM

Hi @sriku I mocked up a workflow that produces the output you describe.

Dates_31072020.yxmd
Reply
0 Likes
get your questions about inspire answered by inspire attendees
learn more about the python upgrade coming in may 2024
Labels