March 31, 2021
I am combining data from folder, which i update daily. I have additional column in combined table, which is edited manually. Problem is that once I updated the next day - this additional column values is not 'saving' his place. So for example when I edit row 100 in additional column, next day this value is assigned to another item.
Do you guys have idea how to solve this?
July 16, 2010
Welcome to our forum!
It is not advisable to manually add a column of data to the query output table for the reasons you have found. If you want to make notes against items in the query output, you're best to do this in a separate table.
Add an index column to your query. Then in your notes table you will have two columns: Index (the number here matches the row in the query table that the note relates to), and the note column.
You can then get the data from your notes table with Power Query and merge the tables using the Index columns to marry them up.
Hope that points you in the right direction.