This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Have you ever used the Allocate tools and received back some strange looking variable names? You're not alone! The Allocate Rename Fields Macro will allow you to rename your fields into readable variables.
The macro can be downloaded here. Note: This will navigate you to the Alteryx Gallery. Select "Download & Install the Allocate Rename Fields Macro" and follow the prompts to install.
USING THE TOOL
The Allocate tools allow users to enrich their workflows with third party data provided from Experian and the US Census. This data contains demographic and household information by geography. Allocate tools can be found under the “Demographic Analysis” tab in the Alteryx toolbar; they include the Allocate Input, Allocate Append, Allocate Report, and Allocate Metainfo.
Allocate Input and Allocate Append tools allow users to select variables to display by geography. Once configured, the fields returned look something like this:
Add the Allocate Rename macro after the Allocate Input/Append. In the Configuration window, select the Dataset that you are pulling from. Press Run for the magic!
Voila! Your field names are now human-readable.
What if my company blocks access to downloading new tools/macros from the Gallery?
In the case that you cannot download this macro, you can use Alteryx to dynamically rename the field names. See is it possible to get the variable name I see in the Allocate tool?
Because most Calgary Databases (files with .cydb extension) contain millions of records with hundreds of fields, a method for allowing a user to quickly determine which records to read is available.
Recently an Alteryx client wanted to select specific records from a Calgary Database containing over 700 million records. The tool the client used to read records was the Input Data tool.
While the configuration of this tool does allow a user to limit the number of records input, it doesn’t provide the ability to select specific records (option 1 in the configuration).
A Filter tool could be attached to the Input Data but this would require all 700 million records be input first. To read 700 million records would require about 10 hours.
The Calgary Input tool enables users to query a Calgary database directly. (For help configuring the Calgary Input tool, see http://help.alteryx.com/current/index.htm#cshid=CalgaryInput.htm).
Since the .cydb file in our example is small (only 15 records), the amount to time it takes to read records using the Input tool isn’t much different than using the Calgary Input tool. However, if this file had contained millions of records, the time savings of using the Calgary Input can be huge.
If you would like see more examples of the Calgary Input tool, sample workflows are available in Alteryx Designer (go to Help --> Sample Workflows --> Data Artistry --> Calgary Tools --> 2. Calgary Input). In addition to Calgary Input, you will find other Calgary related tools.
Attached examples were created using Alteryx Designer 10.1.