Assure DQ

 View Only
  • 1.  Filter the records from a flat file

    Employee
    Posted 06-02-2021 06:27

    Hi,

    We are getting a flat file from an external source and it also has some of the records which not required to be reconciled. How can I filter them out while extracting based on the record type (a column in the file).  Is there any way we can do this inside Infogix Assure?

    Thanks,

    Aasif



  • 2.  RE: Filter the records from a flat file

    Employee
    Posted 06-02-2021 07:52

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    The "Select When" part of extraction is essentially a filter you can put on your extraction. You'll need to configure that so that it only Selects when certain criteria are met.

    You can set said criteria in the bottom pane.