Create Profile by Import From Table—Help

Available with Business Analyst license.

Summary
Usage
Syntax
Code sample
Environments
Licensing information

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_ba (Dataset, InputClusterCodeFieldName, InputCustomerCountFieldName, ProfileFolder, {InputVolumeInfoFieldName}, {InputProfileComments})

Parameter	Explanation	Data 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.7\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

ArcGIS Desktop Basic: Requires Business Analyst
ArcGIS Desktop Standard: Requires Business Analyst
ArcGIS Desktop Advanced: Requires Business Analyst

ArcMap

Create Profile by Import From Table