Test Data Manager

Expand all | Collapse all

How to specify a WHERE Clause while masking EXCEL FILE with FDM

Jump to Best Answer
  • 1.  How to specify a WHERE Clause while masking EXCEL FILE with FDM

    Posted 05-21-2020 04:23 PM
    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


  • 2.  RE: How to specify a WHERE Clause while masking EXCEL FILE with FDM

    Posted 05-28-2020 09:34 AM
    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
    ------------------------------



  • 3.  RE: How to specify a WHERE Clause while masking EXCEL FILE with FDM

    Posted 05-28-2020 05:08 PM
    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


  • 4.  RE: How to specify a WHERE Clause while masking EXCEL FILE with FDM
    Best Answer

    Posted 05-31-2020 07:01 AM
    Please open a support case and provide all details to reproduce internally. 
    FDM, by mistake, thinks that it is trying to mask an xml string.

    Regards, Dahman





  • 5.  RE: How to specify a WHERE Clause while masking EXCEL FILE with FDM

    Posted 06-02-2020 10:32 AM
    ​Hi Abderrahmane,

    Thank you for your reply.  We will open a support case then.

    Best regards,

    Chi-Minh