PowerQuery - Self-referencing table works but whenever there's a change in value in any of the columns of a specific row, manually added comments are removed. How to still retain values in it?
I have the following Power Query table wherein the "Comments" column is a manually added one. This is a self-referencing table that whenever it refreshes as new data come in from a separate master source table, comments will still be aligned to their original rows.
Fruit | Country | Comments |
---|---|---|
Apple | USA | Yum |
Mango | USA | |
Cherry | Canada |
Problem: Everyday, values change as users make modifications to the master source table like changing the spelling of a word. Whenever the PQ table refreshes, the manual "comments" always gets removed. See example:
Fruit | Country | Comments |
---|---|---|
Apples | USA | |
Mango | USA | |
Cherry | Canada |
Goal: Allow users to still make changes in the master source table but initial comments written in the PQ table should be retained. Is there a way to do this?