Jaspal,
If you want to use HASHLOV1, the value you are restricting on has to be the first column in your seedlist.
Typically, the best values to use are province or postal code.
Also, when you are masking you should set keep nulls to 'N' for all fields except the hashcolumn and the restrict value. This will ensure consistency across the address.
------------------------------
Test Data Management Architect
Canada Life
Toronto, ON
------------------------------
Original Message:
Sent: 02-25-2020 01:08 AM
From: Klaas-Jan Lute
Subject: HASHLOV throwing null values
Hi Jaspal,
The default value is returned for the HASHLOV1 when the 'restrict value' is empty. If you want to mask an address using a nearby address you can use the postal code (or a part) as restriction value. The replacement value will then be within the same range. If there is no identical postal code in the seedlist the default is used. I don't know what happens if your hash column is empty. That could be the cause of your problem.
Best regards,
Klaas-Jan
Original Message:
Sent: 02-24-2020 09:57 AM
From: Jaspal Singh
Subject: HASHLOV throwing null values
Thank you for your reply, Klaas-Jan.
Good to know something new regarding HASHLOV1.
I suppose you are referring to add a new column in the seed list with the name : rd_ref_value ='default'.
I am assuming usage of : rd_ref_value ='default' column will be when I will have no value corresponding to the hash value (hash column)
For example, if I am masking street name using address seed list(hashed on street number). How will I make use of : rd_ref_value ='default' (when no value exist in the hash column)?
Thanks, | | Jaspal Singh CA TDM Consultant Information Technology Cluster, WSIB |
Please let me know if you need this message in an alternative format or accommodation to access this email or its attachments.
Si vous avez besoin de ce message dans un autre format ou d'adaptations pour accéder à ce courriel ou à ses pièces jointes, veuillez m'en informer.
Original Message------
Hi Jaspal.
If you are using a regular HASHLOV and youo have an unchecked keep nulls value I can only imagine that your hash value is empty in the file (hash column) or there are null values in your seedlist.
If you are using a HASHLOV1 then there is no value corresponding with the given restrict value. To resolve this you can insert default values in your seedlist (rd_ref_value ='default').
Best regards,
Klaas-Jan Lute