Forum Discussion
Mapping Product Codes form a variety of sources
I have a product file in Business Central and I'm creating a map between the item codes in BC and the item codes supplied to me by the various wholesalers my client uses. I'm doing this in excel....
The answer to this, for anyone experiencing the same problem is fuzzy matching either in excel or (and I found this to be better) Power Query. I’m going to write up what I did and post it here for posterity.