generate data based on substring of current data
I want to anonymize an ID field, but not completely randomize. For instance, there are multiple rows in the table for the same person ID, and also records in another table that should be keyed together. What i want is to keep them all in sync - for instance, if the ID is 123456, i want to keep the last 3 digits but replace the first 3 with a static number - say 456. so in this example i'd end up with 456456 in every place 123456 was. Thoughts?
0 · Share on Twitter