Power query - adding additional column

[agreeff]

Hi all,




I need some advice regarding add an additional column to a sheet merged from two other sheets with power query.


Im trying to import supplier inventory using the suppliers product feed.


The supplier uses two feeds:
"Product" This contains the SKU, Title, Description, Stock on hand, pricing and brand.
"Images" This contains a link to the product image, short and long descriptions.


I used power query to merge the data into one sheet using the SKU to match the rows.


Now here comes my problem.


In the product sheet I added an extra column "Category" where I map each product.
However, when I refresh the query and there are new or removed products, the category I assigned to the product doesn't move up or down the rows with the product.



Eg. Let say product #10, in row #10 is labelled as Category A.
Upon update, lets say two additional products are added. Now product #10 moves to row #12, but Category A doesnt update to row #12.



How can I 'tie' the category to the product maintains the category?


Regards
Agreeff

[Pecoflyer]

Please post a sample sheet and the PQ code. Thx