Combining data to Populate pricing

[Hamurai]

I have a CSV export from the Ecommerce platform I am developing and pricing data in an xls format. The Pricing data has a UPC assigned to it and the CSV export has the same UPC assigned with the rest of the product information. I thought it might be possible to migrate the pricing data to the CSV using power query based on the common identifier of the UPC. If it wasnt to the tune of 1500+ I would gladly do it manually.  I would very much like a step by step or directions to a youtube video that genuinely shows what I am looking for as the tutorials I have found are close but do not accurately reflect the exact steps I personally need to take.

[AnkitKukreja · Accepted solution]

Hi! @Hamurai 

Can you please share some examples of what exactly you are trying to achieve? And if possible share sample data and expected results so we can help you with that.

[Hamurai]

I have this document containing Pricing, UPC, and the name of the item.

then a second document that already has the UPC and MUCH more information and tabs

I would like to populate the PRICE field with the proper prices without having to individually search Each UPC as they arent in the same order/not all on both documents. There are 1500+ products and doing so manually would cost me days. 

[AnkitKukreja]

Hi! @Hamurai 

You have accepted my post above as a solution. Please undo that.

Also, can you copy past like 10-20 rows in here or maybe populate the data in pbix and attach it here, so I can look into it.