This video shows you how to transform column names in bulk. Whether you want to add a prefix, capitalise each word or conditionally replace column values. This video has got you covered. You will learn several different ways on how to achieve this.

WRITTEN BLOGPOST:
[ Ссылка ]

Master Functions and Syntax in M
[ Ссылка ]

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: [ Ссылка ].

Website: [ Ссылка ]

SUBSCRIBE TO MY CHANNEL
[ Ссылка ]

LET'S CONNECT:
Blog: [ Ссылка ]
Facebook: [ Ссылка ]
Twitter: [ Ссылка ]
LinkedIn: [ Ссылка ]

Thank you for your support!

00:00 Introduction
01:02 Understanding Table.RenameColumns
06:19 Using List.Zip
07:06 Method 1: Rename Camelcase
09:03 Method 1: Replace underscores
11:05 Method 1: Add Prefix
13:31 Method 2: Rename Camelcase
15:47 Method 2: Replace Underscores
16:22 Method 2: Add Prefix
17:16 Method 2: Conditionally Rename Columns




#rename #powerquery #bigorilla

свернуть