I need a Powershell script that transform a CSV file by adding a hash column / GUID based on three other columns identified by their headers.
In more details, the original csv file has among other columns :
The output file should have:
- if any of the three original listed columns change, the guid should be different.
- if all three columns are the same, the guid should be the same at each execution of the anonymisation script
- the chance to produce the same hash with different combination should be almost null.
The structure of the hash should be consistent, it can be a GUID but other forms are accepted.
Thanks for your offer.