Building a Raw Index in Calgary Loader

Last modified: May 17, 2023

We have a Database with 3 name fields and we’d like to construct a query that searches any name across all fields and returns the record for the selected name:

Name 1 Name 2 Name 3
Mark Jim Brett
Seth Tara Amy
Margie Lonnie Bob

When creating the Raw Index, stream the database into a Record ID tool and make the starting value 0. This identifies the 1st record in the database as 0 (or a 0-based index).

Transpose the data to align all names in 1 column with the 0-based index in the same row:

RecordID Value
0 Mark
0 Jim
0 Brett
1 Seth
1 Tara
1 Amy
2 Margie
2 Lonnie
2 Bob

Feed the raw index you created into the Calgary Loader tool and configure it as shown below:

Image showing the Calgary Loader tool configuration.

When you then query using the Calgary Input tool, you can select any name and return the record it resides in. The tool knows that "Brett" is located in Record 0.

Image showing the Calgary Input tool configuration.
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.