Has anyone tried to find inventory items that are duplicated but not exactly - i.e. “soft” matches?
We have many items and many of them are redundant. The records represent the same item but the key is not exactly duplicated, of course. We need to set some parameters like similar or identical descriptions, matching Item Type, Class, Price, etc. The idea is to find near-duplicates and present them on a page to be reviewed and updated/inactivated
If someone has already built this or a similar query some help and ideas would be appreciated!