You are here: Tools > All Tools > Allocate Input

Allocate Input Tool

The Allocate Input tool allows the user to pick geographies and data variables from any Allocate dataset installed on the user's system. The most recent dataset used in Allocate will always be the default dataset that opens within this tool.

Configuration Properties:

  1. Choose a Dataset: Use the dropdown list to select an installed Allocate dataset.

    You can specify the default dataset from User Settings. Go to Options > User Settings > Edit User Settings and click the Dataset Defaults tab.

    You can optionally read in an existing Allocate Workspace (*.aws) file:

    1. Select the Use Allocate Workspace checkbox.
    2. Click the Import button to navigate to the workspace file.
    3. Select a file and click Open. Alteryx will read the file and make the appropriate variable and geography selections.
  2. Pick Geography Tab: The selection box on the Pick Geography tab lists all of the standard geography types available.
  3. Pick Variables Tab:The selection box on the Pick Variables tab lists all of the data variables in the selected Dataset.
  4. Special Fields Tab: Use the checkboxes to return any of the following additional fields:

State Name

State Key

County Name

County Key

ZIP Codes by County

Key

RawKey

New Jersey

34

Monmouth

34025

08736 Manasquan

08736

3402508736

New Jersey

34

Ocean

34029

08742 Point Pleasant Beach

08742

3402908742

When specifying the Geography Type in an Allocate Append tool, you will want to ensure to use the RawKey when specifying any geography type that is 'by State' or 'by County.'

Geography

ShortName

Block Groups

BG

CCDs/MCDs by County

MCDbyCNTY

Census Tracts

TR

Congressional Districts

CONG_DIST

Counties

County

DMA

DMA

DMAs by State

DMAbySt

Entire US

FullUS

Metro CBSAs

CBSAMET

Metro CBSAs By State

CBSAMETBYSTATE

Micro CBSAs

CBSAMIC

Micro CBSAs By State

CBSAMICBYSTATE

Places

PLACES

Sectional Centers

SC

States

State

ZIP Codes

ZIP

ZIP Codes by County

ZipByCN

ZIP Codes by DMA

ZipByDma

Related Topics Link IconRelated Topics