Forum Discussion
rhubarb
3 years agoNew Member
Difficulty counting differences between old and new products
Hi, for the sake of this question I have a set of old products which are being migrated to new products. Each product has a set of attributes which I want to compare so that I know how many differenc...
rhubarb
3 years agoNew Member
Thanks for looking lbendlin. The category isn't related to the product though, it's only really there to show that the product mapping isn't always 1 to 1. For example, a customer in Category A with Product 1 is mapped to Product 11 but a customer in Category B with the same product 1 is mapped to Product 21.
In my example I've filtered the page to display for a single row in the mapping table, so in that case should only be one value for each of the relationships of Old Product ID > Product ID and New Product ID > Product.
lbendlin
Super User
3 years agoFor example, a customer in Category A with Product 1 is mapped to Product 11 but a customer in Category B with the same product 1 is mapped to Product 21.
I consider that to be ambiguous. I have not yet understood how such a situation should be handled. Random assignments?