Forum Discussion
Identifying duplicate rows
Hi, I have a table of referral profile information containing fields like name, DoB, email, address etc. If a new referral arrives, that has the exact information as a referral already in the ta...
I think you're looking for something that is pretty similar to this: https://community.fabric.microsoft.com/t5/Desktop/Show-previous-value-of-specific-customer/m-p/295222
As for the similar to previous records, i think you'll need to be more specific with the criteria for what counts as a similar entry (i.e what fields can differ by how much). It will be a lot harder to do this with strings than other data types though.