Cross Count Tool

The Calgary CrossCount tool enables users to aggregate data across multiple Calgary database fields to return a count per record group.

As of the Alteryx 5.0 release, Calgary indexes are case insensitive. Calgary databases created in a version earlier than 5.0 will still be case sensitive.

Configure the tool

Calgary Data File: Specify the Calgary database to select records from, either type in the file path location of the input or click Browse to navigate to the file location.

Linked Data File: If the Calgary Database specified above (Primary file, Household) has been linked to another Calgary Database file (Secondary, Individual), the linked file will be exposed here with a few different options for either returning records or attributes from that linked file.

Linked Options: The different linked options will return records that meet the query criteria built in the subsequent section. It is important to understand that the records returned will consist of a combination of the Primary file and Secondary file only when the query criteria is met.

All Matches: Primary use of this option is when an OR Query is specified. Returns ALL Primary file records and ALL the Secondary file records that meet the query criteria.

The fields from either table can be all NULLs if the record did not link.

All Linked Matches: Returns only the Primary file records and Secondary file records that are LINKED AND meet the query criteria.

The secondary tables fields can all be NULLs if there was no matching linked record.

First Linked Match: All of the Primary file records that meet the query criteria are returned as well as the first linked record from the Secondary file that also met the query criteria.

Last Linked Match: All of the Primary file records that meet the query criteria are returned as well as the last linked record from the Secondary file that also met the query criteria.

Linked Count Only: Only a count is returned representing how many of the Secondary file records met the specified query criteria.

The primary tables fields are still output as normal.

None:No Secondary file records are returned, but the fields from the Secondary file are still available to select in the query criteria.