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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
inna_90 pe Simpatie.ro
 | Femeie
23 ani
Vrancea
cauta Barbat
30 - 48 ani |
|
|
TRaP
Moderator
Inregistrat: acum 8 ani
Postari: 918
|
|
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
|
|
| pus acum 5 zile |
|