Forum Discussion

Lou Mickley's avatar
Lou Mickley
Iron Contributor
Aug 09, 2018

Can manually updated fields exist as columns along side Power Query columns?

I have a table populated by PowerQuery bringing in variable rows from a CSV.  Can I have a column for "Notes" that I update content manually?  Seems when a row is deleted in refresh of CSV, the Notes column does not also adjust and therefore is off one row.

BI & Data Analytics
Power Query

2 Replies

Sort By
  • Kenton Smith's avatar
    Kenton Smith
    Copper Contributor
    Aug 14, 2018

    You can have an additional formula column in Excel that will retain information during a refresh. Create a separate sheet with your notes. Link these notes with a VLOOKUP  via a unique key to your source data.  

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Aug 09, 2018

    Hi Lou,

     

    Nope, that doesn't work such way. Power Query knows nothing about the column you added manually and doesn't sync rows with it.

Resources