I need to compare 2 files containing products( JLS.csv & supplier.csv) , then merge them:
a) Keeping the information that is the same on both (but JLS will have some columns already with data)
b) Remove any rows (going by product ID) on JLS that do not appear on the supplier.csv.
c) Add any rows (going by product ID) that do not appear on JLS but are on the supplier.csv
d) Update anything that is active or inactive on JLS going by the supplier.csv
Basically you are asking JLS.csv file- does this product code exist on supplier.csv(yes, no)? If no then add to JLS if yes then leave. Then asking JLS.csv, do I have any product codes that are not on supplier.csv. (yes, no) if yes then remove from JLS. Then is this product active or inactive (on JLS).