PQ Combining problem

Paweł Pietrzak 1 Reputation point
2021-03-31T10:02:39.357+00:00

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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,254 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,649 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ehren (MSFT) 1,781 Reputation points Microsoft Employee
    2021-04-09T21:55:23.893+00:00

    Try searching online for "power query fill to excel with manual column". One solution would be to create a table that contains the key(s) of your folder data, plus the manual data you want to enter. Then in PQ, merge this table with the folder table.

    0 comments