Inzata Labs

AQL: Add LIKE Operator For Filters

Picture of Nikol H
Nikol H
A passionate tech enthusiast and seasoned tech blogger, Nikol's writing style is characterized by its clarity and accessibility. Whether demystifying the intricacies of artificial intelligence, or guiding readers through the world of data modeling, her articles are a beacon for those navigating the ever-evolving tech landscape.

A LIKE operator for filtering has been added to AQL. This allows users to filter data based on whether a specific attribute matches a given pattern.

The syntax for using the LIKE operator in AQL is as follows:

  • attribute: the attribute on which the filtering is applied
  • pattern: the string pattern to match

Example:

This will return the total

Polk County Schools Case Study in Data Analytics

We’ll send it to your inbox immediately!

Polk County Case Study for Data Analytics Inzata Platform in School Districts

Get Your Guide

We’ll send it to your inbox immediately!

Guide to Cleaning Data with Excel & Google Sheets Book Cover by Inzata COO Christopher Rafter