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
Solved! Go to Solution.
Hi @sriku I mocked up a workflow that produces the output you describe.