Hi
I have two CSV files to import:
Product Swap:
DEL POINT Prod Code Swap Code
1 TEST1 TEST2
2 TEST3 TEST4
Master File:
DEL POINT Prod Code Qty
1 TEST1 2
2 TEST3 5
3 TEST5 10
What I am trying to do is output the Master file, but with the product code swapped based on a combination of delivery point and product code.
So if (Master File.Prod Code & Master.Del Point) equals any record in the 'product swap' file (if which there will only be one entry if exists), then swap the product code.
So in the example above, the outputted single file will show:
DEL POINT Prod Code Qty
1 TEST2 2
2 TEST4 5
3 TEST5 10
Any help much appreciated.


