Dynamic Rename of column headers to Month & Year

Hi All

I'm trying to dynamic rename the column headers from the pic 1 to pic 2. I believe I should be using Formula in Dynamic Rename tool but I have difficulty ensuring that the year will be in accordance to the month e.g. Dec-22 to Jan-23.

This workflow will be reused in subsequent years and the column headers on the 13th run should be Mar-23 to Feb-24.

Thanks in advance.

Workflow

Developer Tools

Custom Tools

Expression

Accepted answers

binu_acs

@ypt the workflow is dynamic, it is taking the current year and calculating the 12 months. If you run the workflow in 2023, it will take that year and calculate the next 12 months and update the column headings

please find the result for the 2023 run

All comments

binu_acs

@ypt One way of doing this

Dynamic_Renamce_0815.yxmd

ypt

Hi @binu_acs

Thanks for the suggested solution. The workflow works fine until the 10th run. As it is based on DateTimeNow, for the last 2 runs which will take place in 2023, the column headers year will move to the Mar23-Feb24.

How can I ensure that the column headers will only change after the workflow has ran for all the months stated in the column headers (at least 12 runs)?

binu_acs

please find the result for the 2023 run

sgwong

I have anothe similar case and I would like to seek your advice to dynamic rename haeder.

Input

Output

Workflow.yxmd

sgwong

can u provide workflow?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335