Рет қаралды 17,494
⏬ Click Show More to check out the description for info and links⏬
Excel and Power BI users sometime need to rename multiple columns automatically rather than manually. e.g. auto replacing parts of the names, or using a manual table of "Before and After" to rename your columns.
I explain 2 methods List.Zip and the simpler Table.ToRows
00:00 Intro
00:20 The Scenario & the general approach
02:11 Create the From and To table
04:34 Creating the List of Lists using List.Zip
07:54 Table.ToRows method
'**************
Nice single line of code solution from Geert in the Comments to extract everything after the underscore
= Table.TransformColumnNames(Source, each Text.AfterDelimiter(_,"_"))
'****************
File to Download
aasolutions.sh...
Matt Allington's video
• Rename all columns in ...
Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/
Connect with me
wyn.bio.link/
accessanalytic...