Basics › Table.RenameColumns4 / 47

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeTable.RenameColumns

Table.RenameColumns: clean up POS export headers

Dimas has just opened a coffee shop in Malang. His POS app exports the menu with technical column names like kd_menu and hrg_jual that confuse his staff.

Task

Rename three columns with Table.RenameColumns: kd_menu to Menu Code, nm_menu to Menu Name, and hrg_jual to Price. The Category column stays as is. Column and row order stay the same as the source.

Data sourcesEksporKasir

Required functionsTable.RenameColumns

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Run previewCtrlEnter
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
Each rename is written as a pair {"old name", "new name"}.
Hint 2
Several pairs are wrapped in one more list, so the braces are doubled: {{"old1", "new1"}, {"old2", "new2"}}.
Hint 3
Table.RenameColumns(Source, {{"kd_menu", "Menu Code"}, {"nm_menu", ___}, {___, "Price"}})

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

let
    Source = EksporKasir,
    #"Renamed Columns" = Table.RenameColumns(Source, {{"kd_menu", "Menu Code"}, {"nm_menu", "Menu Name"}, {"hrg_jual", "Price"}})
in
    #"Renamed Columns"

Explanation

Table.RenameColumns takes a list of { old, new } pairs and only changes names, never the values or column positions. Spaces in new names are fine; inside each such a column is written [Menu Name].
Common mistake: writing several pairs without the outer braces, so the second pair is read as the next argument and the query fails. A typo in an old name also raises a column-not-found error.

Power Query· sources: EksporKasir

let
    Source = EksporKasir
in
    Source

Loading the Advanced Editor…

Edit the M code until the result matches, then press Check answer.

Validation result