search cancel

Masking Function CONCAT returns a NULL when a NULL is in any of the fields being used


Article ID: 242259


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


While testing the CONCAT Masking Function, we noticed anytime one of the fields that are being concatenated together contains a "null" value, the final result of the concatenation is "null".

For example we have the following fields:

First Name
Middle Name
Last Name
Full Name

The masking configuration for Full name is 

Final results in the Oracle database:

We expect the concatenated full name to be something like FirstName (null), LastName, and not (null).


Release : 4.10

Component : Web Portal - Data Masking


This is working as designed.


However, Product Management will place this in the backlog as a possible future enhancement, to process a NULL value as an empty string. Product Management can't commit to making this change, since this could break the behavior that many other customers have requested, but they will look at it and consider it. Perhaps they can add a parameter to how to treat a Null value.