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!

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

Renaming multiple columns in multiple tables

Deku
Super User
1 year ago
Would suggest using TMDL so you could bulk replace via regex or simple searches for text
Anonymous
Not applicable
1 year ago
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
  Not applicable
  1 year ago
  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
    Not applicable
    1 year ago
    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