CONCAT function in FDM on flat file masking

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We need to mask the following query. kindly assist us for the same.

 

for c_id column , we need to concat (branch column's first letter,acc_code,c_srv), need assistance us on how to substring the first letter of branch column to do concatenation with other columns( acc_code,c_srv). 

 

Cause

N/A

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

After further review of the file and your requirement, we can not combine substring and concat functions on flat file masking.

This can be achievable for data in database tables by using SQLFUNCTION masking function. As this function will not work for flat file masking, we can not concat multiple columns along with substring.