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

[sriku]

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

[JosephSerpis · Accepted solution]

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