Make a simple search engine for your data tables

Having a hard time searching for relevant results in your data or spreadsheets? Sometimes it would be nice to just search through everything like a search engine—relevant results, ordered by rank.

The Tables: Find similar text action is an algorithm-powered action that acts just like a search engine. This action uses a powerful feature called fuzzy matching to find similar matches between data, not just exact matches. The action finds and ranks matches even if there is incorrect spelling, spelling variations, or slight differences.

To find exact matches, rather than similar matches, use the action Tables: Look up data in a column.

How the find similar text action works

This action searches a column for a search term. If the action finds similar matches, it returns each result. Each result has a similarity score based on how similar it was to the search term. The action outputs five fields

  • A table of all the matches (Matches Table)
  • The number of matching rows (NumRowsMatched)
  • The most similar result, based on your search term (Top Match)
  • A similarity score for the top match, based on your search term (Top Match Similarity)
  • The difference between the top match similarity and the average (Top Match Similarity Gap)

Check the full output field details for more information.

Find similar text example

As an example, think about a table with data on different apple varieties. There are 3 columns:

  • Varieties
  • Quantity
  • Deliver by

If we wanted to look up information on Honey Crisp and Crispin apples, we could search the table for Crisp and return multiple results. The following illustration demonstrates this:

screen readers look here

For technical details on the algorithm behind this action, see the Technical Details section of the find similar text action.

Add your own search engine

To imitate this functionality, just add the Tables: Find similar text action to your process. All you need is an existing data table to search through.

screen readers look here
  1. First set the table to search through. In this example, the action searches through the “Quotes” table.
  2. Select the columns to search through. If the table has multiple columns, only pick the ones that you want to consider as factors.
  3. Select the search term. In this example, the term is a field reference.
  4. Select the columns to return. In other words, if you find a match in Column A, then return column B and C.

Try this out with a template

If you want to play with an example process that uses this technique, you can get started with a template. Here’s an example of the output from this template:

screen readers look here
An example of the output from the example Workflow

To get started, download the following .catalytic file.

After downloading the template, see How to import a Workflow for how to add it to your team.

Problem with the download?

This file is a unique, Catalytic-specific file type that only works in Catalytic. You cannot open the file on your computer. You only need it when importing a Workflow.

After downloading, if you get the error:

This file does not have an app associated with it for performing this action. Please install an app or, if one is already installed, created an association in the Default Apps Settings page.

This is because you either attempted to open it, or your web browser automatically opened the file after the download. Because this is a Catalytic-specific file type, the error is saying there is no program that can open it. This is to be expected.