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.
When you create 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 a Calgary Input tool, Calgary Join tool, Calgary Cross Count tool, and Calgary Cross Count Append tool.
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.
Browse to the location of the Master Calgary Database file.
Check the box next to the fields of the Master file to link the tables on. Make sure to only check the fields that are present in the file you want to link—otherwise Designer returns an error.
Select Next.
Linked File Tab
The Linked file refers to a smaller *.cydb file, such as a State Individual file.
Browse to the location of the Calgary Database file you want to link to the Master file.
Check the box next to the fields of the Liked Calgary Database file to link the tables on.
Note
Only check the fields that both files have in common.
Finish
Select Finish.
The app runs and reports "No Output Files" on completion. So long as the app runs error-free, it creates these files in the Master File directory location and the Linked File directory location:
Master File Directory Location
MASTERFILENAME_LINKS.csv
MASTERFILENAME_@LINK@LINKEDFILENAME.cyidx
Linked File Directory Location
LINKEDFILENAME_LINKS.csv
LINKEDFILENAME_@LINK@MASTERFILENAME.cyidx