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.
Note: This tool is no longer available (see here). Links in this article may be broken.
Have you ever used the ConsumerView Analytical File in US Core Data and stared wide-eyed at the codes returned? There is now an alternative to looking in the documentation for the coded values! The ConsumerView Renaming Macro allows you to rename the codes into readable data.
The macro can be downloaded here. Note: This navigates you to the Alteryx Gallery. Select "Download" and save to a directory. First time installing a macro? Use the guide here.
USING THE TOOL
The Calgary tools allow users to enrich their workflows with third party data, such as the ConsumerView Analytical file. ConsumerView is a marketing database providing insight on more than 221 million customers and 134 million household units. Calgary tools are found under the “Calgary” tab in the Alteryx toolbar; they include the Calgary Input, Calgary Join, and Calgary Loader.
Once a Calgary Input is configured for either the Experian Individual or Experian Household data file and a query is added, the fields returned look something like this:
Add the ConsumerView Renaming Macro after the Calgary Input. In the Configuration window for the macro, select the Dataset you are pulling from, either Household or Individual, and add a Browse tool. Press Run for the renaming!