Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to update a Column Header when data is refreshed

I have a Power Query, where I add TWO Custom Columns from two Blank Query referencing "SheetCellA1". I then move the new columns to the first/second position. I remove the top 2 rows, and then "use...
Need Help
Tutorial Requests
PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Anonymous 

Isn't this the same question you posted here and solutions were provided

https://community.powerbi.com/t5/Power-Query/How-to-update-a-column-name-when-data-is-refreshed/m-p/1479531#M46104

#"Renamed Columns" = Table.RenameColumns(#"Promoted Headers",{{Table.ColumnNames(#"Promoted Headers"){0}, "TIME"}, {Table.ColumnNames(#"Promoted Headers"){1}, "MARKET"}, {"Column3", "SEGMENT"}, {"Column4", "SUB-SEGMENT"}, {"Column5", "UPC"}, {"Column6", "DESCRIPTION"}, {"Column7", "SIZE"}, {"Column8", "FLAVOR"}, {"Column9", "BRAND"}})

Regards

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PhilipTreacy  It is- This one was marked a "Spam" so I reposted.  How do I delete this duplicate post?

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    Don't repost Anonymous if marked as spam. The spam is automatic, but it is usually reviewed VERY quickly by a human to unmark it if it is a genuine question.