FIXEDUNIQUE function is not working for columns containing spaces

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.