Header mapping

[Anonymous]

Hi,

I have source data, which comes with different column names monthly. I need to map the headers as per my master table. 
The master table has the standard field names (in Column 1) and the the field name from the source data (in Column 2).
I need to map or change my headers as per my master data. 

Please advise how can we achieve this on powerbi

Source DATA

INV Number	INV Date	Invoice Desc
INV001	20/04/2022	Desktop Sales
INV002	20/04/2022	Export Goods

Master Mapping Table

Standard Column	Raw Data Fields
Invoice_Number	INV Number
Invoice_Date	INV Date
Invoice_Description	Invoice Desc

[HotChilli]

There is a power query function Table.RenameColumns  which can do this in one stage.  The easiest usage will be to hardcode the column replacement names in the function call rather than retrieve the names from a table but you can probably do that too .

https://docs.microsoft.com/en-us/powerquery-m/table-renamecolumns