ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

FIXEDUNIQUE function is not working

book

Article ID: 227072

calendar_today

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.

Cause

This is a configuration issue where another option needs to be added for columns having only spaces.

Environment

Release : 4.9.x

Component : Fast Data Masker

Resolution

Use below option in your options file:

TRIMVALUES=N

 If it's set to Y (or if it's missing) then all blanks values (values containing only spaces) are retained as they are.