You are here:

Calgary Create Link App

The Calgary Create Link App allows the user to link Calgary Databases. By linking Calgary databases, users can easily append customer data to a static, master database and quickly query from either database.

By creating a link using this Analytic App, an option for returning linked tables will be visible in the configuration properties of individual Calgary tools such as the Calgary Input, Calgary Join, Calgary Cross Count, and Calgary Cross Count Append tools.

Analytic App Instructions

Go to Options > Run Analytic Apps and run the Calgary Create Link App.
Master File Tab: The Master file refers to a large, static *.cydb file, such as a U.S. Household File.
1. Browse to the location of the Master Calgary Database file.
2. Check the box next to the fields of the Master file to link the tables on.
  - Be sure to only check only the fields that are present in the file to be linked, otherwise an error will be returned.
Click Next.
Linked File Tab: The Linked file refers to a smaller *.cydb file, such as a State Individual File.
1. Browse to the location of the Calgary Database file you'd like to link to the Master file.
2. Check the box next to the fields of the Linked Calgary Database file to link the tables on.
  
  Only check the fields both files have in common.
Click Finish. the App will run and report "No Output Files" upon completion. As long as the App runs error free, it will create the following files:

The following 2 files will save to the Master File directory location:

MasterFileName__Links.csv
MasterFileName_@Link@LinkedFileName.cyidx

The following 2 files will save to the Linked File directory location:

LinkedFileName__Links.csv
LinkedFileName_@Link@MasterFileName.cyidx