Does TDM have the ability to find specific PII information via Profiling?

Document ID : KB000004099
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

We are just starting to look at PII profiling within GT Datamaker.  There is not an option to highlight and go search for specific PII data based on the selection.  How can the program look for specific data in a set of tables?  In this business case, the need is to look for a comma in a name in a column.  Can this be done, and if so, how?

Environment:
TDM 3.5
Resolution:

The way to do this is to open a custom filter and to use a RegEx statement to look for your specific criteria.  In this case, the power of RegEx and the Custom Filter is demonstrated with the following:

[^,]+

Additional Information:

If you experience any issues, please open a support case by going to https://www.ca.com/us/services-support/ca-support/contact-support.html