search cancel

FDM Query on Data masking using the values in a second column

book

Article ID: 201791

calendar_today

Updated On:

Products

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

Issue/Introduction

Suppose I have a column called  'A' with 10 digits in length 
I also have a column called 'B'  

      A                                          B
1234567890                           SAM
2345678912                           HELLO

I want to mask column A and replace the first 5 digits with column B.

Post masking :
SAM   67890  (with 2 spaces)
HELLO78912

Could you please suggest what masking algorithm / approach can this be achieved?

Cause

NA

 

Environment

Fast data Maker (FDM) 4.9.x

Resolution

FILL the first 5 characters of A with a space, followed by SQLFUNCTION left(B,5)

(select the "use masked values" checkbox)

FDM allows you to specify multiple mask routines on the same field.

Datamaker/Transformation Maps only let you specify 1;  
You'll have to manually update the exported .csv file to reflect the 2nd function execution.

Additional Information

You'll have to provide your own Database reflecting the structure/content that John provided.  
FDM mask & options files attached.

The above work for MS SQL server and mainframe as they both support the LEFT function.
Oracle database does not and you will need to use the SUBSTR

Attachments

1603211008108__john-mask-a-b_options.txt get_app
1603210993785__john-mask-a-b.csv get_app