Audimation Services has been acquired by Caseware International Learn More.


Chapter 16: Key Value Extraction

CaseWare IDEA 10 Tutorials

Chapter 16: Key Value Extraction Transcript

Previously, we looked at criteria to filter records and direct extraction to pull records which met conditions we provided. In this exercise, we’ll look at key Value extraction, a visual method of building extraction criteria to see a list of Payment Types and product codes. Specifically, I want to see transactions for product code 5 and 6, paid for by Visa.

To start, ensure the Sales Transactions file is active, the data property is selected in the properties window and that no criteria are in place. Next, click the Analysis tab and in the Extract group, select Key Value. The Key Value extraction dialog appears. You can choose to use an existing key or, to build a new key, click the browse button.

In the first row, enter payment type, and in the second row, select product code and click OK to return to the Key value extraction dialog. You are now presented with a list of all the payment types for each product code. As mentioned, we want to see Visa payments for product codes 05 and 06. It would be faster to clear all the entries and pick these two out of the list rather than deselect each entry one by one, so click the Clear all button and then scroll to the bottom to find Visa + 05 and Visa + 06. The default behavior for this dialog is to generate a separate database for each key combination selected. This can be changed by clearing the Create separate database for each unique key checkbox. Click OK to generate the output.

Two new databases are created and visible in the File Explorer. The first one is opened up in the database window. KeyVal = Visa + 05 isn’t a great name, so let’s change this. Close the file in the database window and right click on the file in the File Explorer. Select rename file and enter a new name such as Visa Payment for Product Code 05. Do the same thing for 06.


This website has been designed for modern browsers. Please update. Update my browser now