search cancel

Use of Where clause through Fast Data Masker for Flat files - example

book

Article ID: 201540

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

One of our stake holders would like to apply 'filter' condition on some columns of a flat file (.csv). 
Can you point me to the documentation that will throw more light on using this feature? If possible, point me a description with use of where clause. 

For your reference a couple columns has AlphaNumeric IDs, and  we are going use FormatEncrypt algorithms, Similarly, for date fields, how do I give conditions, what is the syntax. etc. 

Environment

Release : 4.9

Component : CA Test Data Manager

Resolution

Here is an example of a csv file (showing AND and OR support)



Table,Column,Function,Parm1,Parm2,Parm3,Parm4,Keep Nulls,Date Format,Cross Reference,Override SQL,Unique Columns,XPath Element,Substr start,Substr length,Notes,Preformat,Update,Use Masked Values,Restart Column,From Occurance,To Occurance,Parm5,Parm6,Parm7,Parm8,Parm9,Parm10
Feuil1.DM.TXT,,WHERE,ID='3',,,,,,,,,,,,,,,,,,,,,,,,
Feuil1.DM.TXT,,AND,ID='1',,,,,,,,,,,,,,,,,,,,,,,,
Feuil1.DM.TXT,TEXT,FORMATENCRYPT,,,,,Y,,,,,,,,,,,,,,,,,,,,
Feuil1.DM.TXT,,WHERE,ID='3',,,,,,,,,,,,,,,,,,,,,,,,
Feuil1.DM.TXT,,OR,ID='2',,,,,,,,,,,,,,,,,,,,,,,,
Feuil1.DM.TXT,NUMBER,FORMATENCRYPT,,,,,Y,,,,,,,,,,,,,,,,,,,,