Log In
Register
Home
New Member
March 31, 2021
Offline
Hi,
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?
Yours faithfully,
PP
July 16, 2010
Offline
Hi Pawel,
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.
Mynda
1 Guest(s)
