Renaming multiple columns in multiple tables

[Nozama]

I have circa 25 tables in my model. None of them have dependencies or anything (joins etc.). Each of them have 215 columns. The headers in all columns are differently typed, some with underscores, some with dots and other punctuation. I want to rename all columns of all these tables as per a standard list etc. What is the best way to achieve this please? Thanks!

[Anonymous]

Hi @Nozama,

Thanks @Deku for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[Anonymous]

Hi @Nozama,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[Anonymous]

Hi @Nozama,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[Deku · Accepted solution]

Would suggest using TMDL so you could bulk replace via regex or simple searches for text