question

PawePietrzak-8779 avatar image
0 Votes"
PawePietrzak-8779 asked Ehren answered

PQ Combining problem

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

power-query-not-supportedoffice-excel-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PawePietrzak-8779,
I suggest you try to provide the sample or steps about how to reproduce the problem, so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

0 Votes 0 ·

1 Answer

Ehren avatar image
0 Votes"
Ehren answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.