May 30, 2020
I load some project data into an excel table from a powerquery. The data in the powerquery comes from a sql server view. Now the user wants to add an extra column 'Notes' in the excel table. This column is not part of the view/database table. The data is this column must be preserved and shown in the column as long as the project shows up in the result list of the view.
Is there a way to accomplish this?
Ruud de Heij
July 16, 2010
Welcome to our forum!
Because the query and the extra column are not from the same source, i.e. all from Power Query, there is a risk that the order of the data in the query becomes out of sync with the order of the notes.
Perhaps the safest way to keep them in sync is to add an index column to the query data and enter the notes in a separate table with the relevant index number that relates to the query data. Then load the notes table into Power Query and merge the two tables using the index number to match them up. That way the notes will always correspond to the correct row of the query, even if it gets sorted in a different order.