How to use custom fields (IQL)

Impira puts the power of data modeling in your hands. Not only can you create machine-learning-based extraction fields, but you can also create manually entered fields as well as custom fields.

Custom fields (i.e., 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 custom fields.

In Impira, you can create custom 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`)
Note: Any field names that have multiple words or spaces need to be encased in backticks (`).

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

  1. Hit Create.

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

In this example, you have a Collection of applications and you want to determine the amount of days between when the application was submitted and when an application was closed.

You could extract the fields, Submission date and Close date, then create a new custom field to determine how many days went by between the two dates.

  1. Add a new field with the + button to the right of your Collection.
  2. Name your field — e.g., “Days to close”.
  3. For Type, choose Add a custom field (IQL).
  4. For Expression, use:
(`Close date`-`Submission date`)/24/60/60
Note: Any field names that have multiple words or spaces need to be encased in backticks (`).
Note: The difference between the dates is returned in seconds since the date fields are stored as UNIX/epoch timestamps, 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.

You'll see a new field appear in your Collection populated with Days to close values:

© 2023 Impira Inc. All rights reserved. This site is built with Motif.