FIXEDUNIQUE function is not working for columns containing spaces
Article ID: 227072
Updated On:
Products
CA Test Data Manager (Data Finder / Grid Tools)
Issue/Introduction
When the column to be masked is having all spaces, then the FIXEDUNIQUE function is not working and not appending the sequence number.
Environment
FDM 4.9.1+
Cause
This is a configuration issue where another option needs to be added for columns having only spaces.
Resolution
Use the below option in your options file:
TRIMVALUES=N
If TRIMVALUES is set to Y (or if it's missing) then all blanks values (values containing only spaces) are retained as they are.
Feedback
Yes
No
Powered by
