N
N
Nikolai2017-01-09 22:33:16
excel
Nikolai, 2017-01-09 22:33:16

How to map a column in a Power Query?

In an Excel 2016 table, using power query, I create a query to the xslx table, I load the data into a sheet. Next, you need to add a column (columns) with a parameter added manually to the received data.
0b8d9539ae86481897f6f16c8dbf6ba8.png
The next day, by request, we update the data in the sheet, but the changes made are lost, since some rows are added in the donor, some are deleted.
9ce5c67a45c54fe4afeeca152efe5ca5.png
How to bind the changes made to the table to the donor? There is a column with unique data (article).

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question