Hi Ruth,
Thanks for the response.
I already did some tests with the WHERE-CLAUSE and I'm always getting a warning message from FDM saying that the WHERE clause is not supported for XML. FDM still finishes the masking process and all the data are scrambled regardless of the WHERE-CLAUSE .
My input excel file looks like this:
The WHERE-CLAUSE in FDM :
The expected results should be only the TEXT and NUMBER in the rows 2,3 and 4 are going to be scrambled.
Instead, the scrambled file looks like this. TEXT and NUMBER in rows 5,6,7,8 are scrambled.
In the log file :
>2020-05-28 16:03:27.287 starting masking at 2020.05.28 16:03:27.287 EDT
>2020-05-28 16:03:27.677
WHERE clause not supported for XML , use conditions in the XPATH >2020-05-28 16:03:27.881 masking complete at 2020.05.28 16:03:27.881 EDT
>2020-05-28 16:03:27.881 Total time taken 00:00:00:594
>2020-05-28 16:03:27.881 Masked data written as E:/test(scramble).xlsx
I don't know what FDM means by saying "Use conditions in the XPATH". Any ideas ?
Thanks,
Chi-Minh
Original Message:
Sent: 05-28-2020 09:34 AM
From: Ruth Kusterer
Subject: How to specify a WHERE Clause while masking EXCEL FILE with FDM
Hi Chi-Minh,
I found the following example of using WHERE clauses for masking, and it reminded me of your question.
http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/devops/test-data-management/4-9/mainframe/masking-functions-for-mainframe/mask-flat-files-using-where-clauses.html
Does this help?
------------------------------
Technical Writer
Broadcom / CA
Original Message:
Sent: 05-21-2020 03:40 PM
From: Truong
Subject: How to specify a WHERE Clause while masking EXCEL FILE with FDM
Hi,
I want to specify a WHERE clause when masking an Excel file with FDM. Anyone know how to do this?
For example: I want to mask only the rows where the value in the column A = "1"
Thanks,
Chi-Minh