How to Filter Data with ADA

Introduction

ADA (Audit Data Assistant) provides a handy utility for filtering data to quickly and easily get just the data you need.

Using the Filter Dialog

Filter gives you a number of options for filtering data:

filter audit data dialog

Subset of Records. Check the Subset of Records checkbox to select a particular set of records by record number. Filter automatically fills in 1 in the first box and the number of records in your data in the second box. For example, the above file has 50 records, so that is the number you see in the second box. If you wanted to select records 2 to 5, you would type 2 in the first box and 5 in the second box.

Criteria. ADA utilities use criteria to filter data. Criteria are powerful formulas that specify the exact data you want. If you wish to filter out orders from Texas or invoices over $1000, criteria can do that.

Here is an example of a formula that filters out only U.S. Data:

Criteria

You can either type your criteria formula into the box or double-click the box to access the Criteria Editor dialog. For a more comprehensive overview of Criteria, see How to Write Criteria in ADA.

Included Columns. By default, all of the columns in your data set are selected. If there is a column you don’t wish to include in the filtered data, simply click that column name to deselect it. Accidentally deselected a column that you actually want to include in the filtered data? Click it again to select.

Output Name. Name your filtered data file. It will be saved in the project folder with a .parquet extension. Here, the output file with be named US filtered data.parquet.

Formats Supported by Filter

ADA’s Filter utility allows you to filter Parquet data. Parquet is the format ADA uses for storing data files.

Questions

If you have questions about ADA software or you would like to know about purchasing custom ADA analytics, wonderful! Please call us at (864) 625 – 2524, and we’ll be happy to help.