data refresh error

[Anonymous]

Hello,

I am new this forum.

Whenever I refresh to bring in new data from excel based source, I receive this error: = Table.RenameColumns(#"Filtered Rows",{{"AccessoryCost","AccessoryCost"}, {"HdwCost","HdwCost"},{"Fee","Fee"}})

I do not understand what it means or how to correct

also getting this one too: Table.ReorderColumns(#"Kept Errors", {"Row Number", "Channel", "PaymentMethod", "Type", "Invoice", "InvoiceDate", "OrderDate", "CustName", "CustTerritory", "DealerCode", "MSD", "UserName", "CellPhoneNo", "PortedCTN", "VoicePlan", "DataPlan", "WebOrderID", "Type2", "Qty", "PartNumber", "Item", "IMEIESN", "Hdw Cost", "HdwSellPrice", "TopUpOwing", "Accessory Cost", "AccessoryPrice", "TopUp Acc", "TopUpTotal", "Fee", "Transactions", "ARAmount-ARTaxes-CCGrossSale", "RV-UEValue", "HDWChargeToCustomer", "HDWRV-UEValue", "True HDW TopUp", "HDWMargin", "ACCChargeToCx", "AccMargin", "FeePayback", "Missing Header 1", "Missing Header 2", "Group", "AccSellingPrice", "AccQtys", "GST-HST", "PST-QST", "Total", "R4BOrderID", "ReturnClassification", "Comments", "Month"})

Expression.Error: The column 'Hdw Cost' of the table wasn't found.
Details:
Hdw Cost .... i belive in the source table (excel file) the column header was changed to "HdwCost"

[amitchandak]

@Anonymous , Change it manually in all steps

example

Table.ReorderColumns(#"Kept Errors", {"Row Number", "Channel", "PaymentMethod", "Type", "Invoice", "InvoiceDate", "OrderDate", "CustName", "CustTerritory", "DealerCode", "MSD", "UserName", "CellPhoneNo", "PortedCTN", "VoicePlan", "DataPlan", "WebOrderID", "Type2", "Qty", "PartNumber", "Item", "IMEIESN", "HdwCost", "HdwSellPrice", "TopUpOwing", "Accessory Cost", "AccessoryPrice", "TopUp Acc", "TopUpTotal", "Fee", "Transactions", "ARAmount-ARTaxes-CCGrossSale", "RV-UEValue", "HDWChargeToCustomer", "HDWRV-UEValue", "True HDW TopUp", "HDWMargin", "ACCChargeToCx", "AccMargin", "FeePayback", "Missing Header 1", "Missing Header 2", "Group", "AccSellingPrice", "AccQtys", "GST-HST", "PST-QST", "Total", "R4BOrderID", "ReturnClassification", "Comments", "Month"})

refer: How to Deal with Column Rename at Source - https://youtu.be/meUxcbwujl8