Hi,

I have two .csv files >

File 1:

Product_Code : ProductName : Product_Price : Product_Availability
1 : product1 : 10 : 89
2 : product2 : 20 : 54

File 2:


Product_Code : ProductName : Product_Price : Product_Availability
1 : product1 : 9 : 20
2 : product2 : 30 : 264
3 : newproduct3 : 25 : 10

I am looking for a method to update Product_Price and Product_Availability in File 1 from the updated data in File2 based

upon a unique Product_Code. I would also like new products found in File 2 (where product code doesn't exist in File 1)to be

appended to the bottom of File 1.

any help would be greatly appreciated. Thanks in advance