Column renaming - where column name in dataset are not fixed

[ilovecoding]

Hi, My base dataset is not fixed and headers keep on changing every month. Hence Select tool is out of question

Otherwise how can i change my headers ? Dates keep on changing every month

Current dataset format

Desire result

[Raj]

do you want dates in place of previous and current?

[ilovecoding]

i Want previous and current in place of dates

[PangHC · Accepted solution]

if it always last 2 columns.

if it always 2nd and 3rd, you can remove sort, and one of the recordId.

[Christina_H]

I would calculate the dates you want to change and use a dynamic rename tool.

Formulas:
Previous: DateTimeFormat(DateTimeTrim(DateTimeAdd(DateTimeToday(),-1,"month"),"lastofmonth"),"%d-%b-%Y")

Current: DateTimeFormat(DateTimeTrim(DateTimeToday(),"lastofmonth"),"%d-%b-%Y")

These are based on the assumption that "Current" means the current month, but you can easily change them to whatever you need with DateTimeAdd, e.g. you might need -1 and -2 months.