Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
monaahmed2012
 | Femeie
25 ani
Calarasi
cauta Barbat
25 - 48 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| pus acum 2 luni#1 |
TRaPModerator
Postari: 960
|
|
key words: power query excel rename columns formula
I have a few column headers that in the original file contain references/notes marked with the asterisk character (*).
I need a power query step to rename all columns containing that character and removing it.
1. Click on the last step (or desired step) in your Query Settings, and select "Insert Step After".
2. In the formula bar, add the following formula making sure you rename the previous step according to your own, and the replaced and replaced with parameters with your own as well:
| = Table.TransformColumnNames(#"Removed Columns", each Text.Replace(_, "*", "")) |
Source: ChatGPT
|
|
| |
|
