Forum Discussion
Anil2264
4 years agoHelper I
Dynamically column name change in power query from Excel
Hi Team,
I am having column names which are having 1000 length and more but i want a dynamic column name as per my requirement using abbreviation for that column. Kindly suggest how we can achieve it.
amitchandak Please help
Thanks in advance
3 Replies
- AnonymousNot applicable
Anil2264
If you just want to create abbreviations for multiple column names You can use Table.Renamecolumns.Table.RenameColumns - PowerQuery M | Microsoft Docs
- jennrattenSuper User
Are you wanting to map the current column names to corresponding abbreviate versions or just limit the number of characters in the column names?
- Anil2264Helper I
I want to squeeze my column size in report & if it is squeezing size then it has to be renamed as per required name