Get our latest book on "Top 10 artificial intelligence myths."

Last updated

March 3, 2021

Table of contents

How to use computed fields

Impira puts the power of data modeling in your hands. Not only can you create Machine Learning (ML) based extracted fields, but you can also create manually-entered fields and computed fields as well.

Computed fields allow you to get your data in the exact form you need it.  If you’ve ever entered a formula in Excel or Google Sheets, then you’re already aware of the concept of computed fields. In Impira, you can create computed fields within a Collection, or use the Join function to connect values across Collections.  The ‘computation’ options include not only basic arithmetical and string functions, but logical functions and even advanced regex.  Let’s take a look at a couple of simple examples:

Example: Concatenating name fields

If you have extracted fields for ‘First name’ and ‘Last Name’ but need a single field you would like to call ‘Name’, simply add a new field by clicking on the

(Add Field) button, and name it ‘Name’ , change the Type to ‘Function’ and enter the following expression:

concat(`First Name`," ",`Last Name`)

This function concatenations three values:

1) the First Name field

2) a blank space and

3) the Last Name field

Your new table might look something like this:

A full list of these built-in functions, such as concat, can be found here.

Example: Function on date fields

If you wanted to find out how long an application took from the time of submission until it was acted on, you could extract Date fields for ‘Submission  Date’ and ‘Start Date’ and then create a new calculated field applying some arithmetic to the extracted values:

Again, you’ll add a new field, and set the type to ‘Function’  in this example, the function would be:

(`Start Date`-`Submission  Date`)/24/60/60

Since the Date fields are stored as UNIX/epoch timestamps, the difference between the dates is returned in seconds, so dividing by 60 gives the number of minutes, dividing by 60 again gives the number of hours, and dividing by 24 gives the number of days.  

After adding this field, your Collection might look like this: