Renaming Columns in Numerical Order

[briankuhlmann]

I have a dataset where each week, a new column with a date header will be added. Is there a way to rename these date columns 1, 2, 3, etc?

[PhilipMannering · Accepted solution]

Hi @briankuhlmann 

Something like this?

[briankuhlmann]

what im asking for might now be possible, but i need to ignore the item and soldby columns. Every week a new column will be added with a week number. For instance, next week 04/24/2022 will be added. 

I need to convert the columns with date headers to 1,2,3,4, etc so i can use formulas to compare weeks.

[PhilipMannering]

Liiiiiike in my post?

[PhilipMannering]

See above.

[PhilipMannering]

...in case you missed it.

[briankuhlmann]

thanks!

[jbichachi003]

Hi @briankuhlmann,

Absolutely!

Instead of using the Dynamic Rename tool, I would recommend you pivot the data using a Transpose, update the field names, and the pivot the data back using a Cross Tab.

Pivoting example

See the attached example.

Hope it helps!

[PhilipMannering]

@jbichachi003 Not sure that'll work for more than one record. But you could use the MultiRow Tool or Tile Tool in place of the RecordID Tool.

[jbichachi003]

@PhilipMannering,

Good point!

I updated it to account for multiple rows.

Updated pivoting example