Join us October 22nd to hear Coglate-Palmolive, IDC, and Sequoia Capital discuss moving to a digital-first environment
Learn more

Last updated

January 11, 2022

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-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

Let’s say you’ve already extracted the fields First name and Last name from a set of files, but you want to combine them into a single field called Full Name

  1. Open your Collection and click the + on the right side of your table. 
  2. For Name, enter “Full Name.”
  3. For Type, select Create custom field (IQL).

  1. For Expression, enter the function: concat(`First name`," ",`Last name`)

This function concatenations three values: The First Name field, a blank space, and the Last Name field.

  1. Hit Create.

Your new table will now include a column for Full Name.

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

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:

Stay in the loop

Get our Release Notes hot off the press, straight into your inbox.

Need more help?

Talk to someone