Forum Discussion
Auto-rename all Query columns e.g. to remove underscore
It is up now, thanks everyone https://msdn.microsoft.com/en-us/library/mt674878.aspx
thanks arify - at least that function is exposed now. I found your last example in the thread above much more useful than the one posted in the documentation. That scenario (special characters in column headings) seems very unlikely.
Anyway I had to loop back to this to do something similar - inserting spaces for "Camel Case" column names e.g. CustomerName. So I have built a couple of examples using Table.TransformColumnNames and added it to my list of demo files (link below) for future reference - it's the one named:
Power Query demo - Renaming Columns automatically
mike_honey I just downloaded it and tried it out, it's pretty cool! I want to look around at that folder some time :)
mike_honey - would love to see this demo file. I checked, but perhaps it's no longer in the OneDrive location? Any way for me to access it?
Thanks,
Ryan
thephotobus - its still there. Try the button at top-right to change to list view.