community
cancel
Showing results for 
Search instead for 
Did you mean: 

Location Data Knowledge Base

Data methodologies, and Release schedules.

Renaming Allocate Variables

Moderator
Moderator
Created on

AllocateRename.pngHave 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 hereNote: 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: 

 

Pre-format.png

 

 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!

 

 

macro.png
 

Voila! Your field names are now human-readable. 

 

post-format.png

 

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?

Comments
Meteor

Does this work if you are using the Data Bundles installed from a network location? I consitantly get that no allocate data sets available, even though I am using this after an allocate input.

Moderator
Moderator

@DataGrrl do you have the same issue when trying to use the Allocate Metainfo tool? Are you able to select a dataset in the Allocate Rename tool, or is the list blank?

Alteryx Alumni (Retired)

This should work regardless where the data is installed. Is the connection to the network location stable? If not, Allocate datasets may not be seen.

Is Alteryx set to Disable Auto Configure?  If so, the Allocate tools may need refreshing to see available datasets.

Meteor

I can see the Allocate datasets fine in the Allocate Input Tool and Allocate Metainfo, but the Macro has "--No Allocate Datasets Available"

Meteor

I've downloaded the Allocate Rename macro but can't see it in the list of tools in Alteryx designer still. How can I access it in the workflow?

 

Thanks

Meteor

Nevermind, I figured it out! Thanks.

Meteoroid

I've downloaded the Allocate Rename macro but can't see it in the list of tools in Alteryx designer still. How can I use it?

 

Thanks a lot!

Labels