Marc on 20 Jan 2016 04:08:51
Often the various data sources that I am working with have very technically obsolete names (Hungarian notation?). It would be great to allow for a more fluid renaming of columns in the edit query portion of the desktop tool. This would aid in the time spent as I rename each and it has to reload the data source only to have me do that again for 5+ columns.
- Comments (2)
RE: Ability to rename multiple columns from a query at a time.
There definitely needs to be a smoother way to rename a series of columns. We often have a series of 4 groups of columns, each group having 12 or 24 time periods. Renaming these in Excel is easy; in PBI, it's a real pain :-(
RE: Ability to rename multiple columns from a query at a time.
Hi Marc. Not sure if this is what you're looking for, still hope it helps.
After a Merge I ended up with around 90 columns starting by "NewColumn."
To rename, I did the following:
1. Turned Rows into headers
2. Breath deep and transposed the table (and after long time loading my computer survived, luckily)
3. Replaced the undesired values. Being all rows within the same column this is done in a jiffy.
4. Transposed again (this time it's easier on the loading since there aren't so many columns)
5. Promote first row to header.
I wouldn't recommend this trick if you're working over hundreds of thousands of rows. I rarely work with over 50k rows so this does the trick, but do it for a larger number and say hello to Ctrl+Alt+Supr.
Hope this helps.
Regards!