ArcMap

Create Profile by Import From Table

Available with Business Analyst license.

Summary

Creates a profile from a table of aggregated segmentation information. For example, this tool will create a profile from a table of records that summarizes the count of customers for each segment.

Learn more about how Create Profile By Import From Table works

Usage

  • Input tables must be in a format that can be opened in ArcGIS.

  • The Import Table must contain summarized counts for each segment. The table should only have one record for each segmentation code.

  • If the Import Table contains multiple records for each segmentation code, you should use the Create Profile From Segmentation Coded Table tool.

Syntax

CreateProfileByImportFromTable(Dataset, InputClusterCodeFieldName, InputCustomerCountFieldName, ProfileFolder, {InputVolumeInfoFieldName}, {InputProfileComments})
ParameterExplanationData Type
Dataset

Table containing segmentation codes and attributes.

Table View
InputClusterCodeFieldName

Field in the input table that contains the segmentation codes.

Field
InputCustomerCountFieldName

Field in the input table that contains the count of records for each segment. For example, this could be the number of customers in each segment.

Field
ProfileFolder

The output profile is created in this folder. The folder name corresponds to the name of the profile used in Business Analyst. For example, a profile created in the folder C:\My Output Data\Projects\Default Project\Segmentation\Profiles\NewProfile would be referred to as NewProfile in Business Analyst.

Folder
InputVolumeInfoFieldName
(Optional)

Optional field in the input table that contains aggregated volume information for each segment. For example, this could be the total sales for each segment.

Field
InputProfileComments
(Optional)

Optional comments for profile. These comments can include information such as author, source, date, and vintage.

String

Code sample

CreateProfileByImportFromTable example (stand-alone script)

# Name: CreateProfleByImportFromTable.py
# Description: Creates a segmentation profile from a table that contains segmentation distributions.
# Author: Esri

# Import system modules
import arcview
import arcpy

arcpy.ImportToolbox(r"C:\Program Files (x86)\ArcGIS\Desktop10.8\Business Analyst\ArcToolbox\Toolboxes\Business Analyst Tools.tbx")
 
try:
# Acquire extension license 
  arcpy.CheckOutExtension("Business")
 
# Define input and output parameters for the Create Profile by Import From Table tool
  Dataset = "C:/temp/Profile.dbf"
  InputClusterCodeFieldName = "CodeFld"
  InputCustomerCountFieldName = "CountFLD"
  ProfileFolder = "C:/temp/NewProfile.xml"
 
# Create Profile by Import from Table
  arcpy.CreateProfileByImportFromTable_ba(InputTable, InputClusterCodeFieldName, InputCustomerCountFieldName, ProfileFolder)
 
# Release extension license 
  arcpy.CheckInExtension("Business")
     
except:
  print arcpy.GetMessages(2)

Environments

This tool does not use any geoprocessing environments.

Licensing information

  • Basic: Requires Business Analyst
  • Standard: Requires Business Analyst
  • Advanced: Requires Business Analyst

Related topics