Create Profile by Import From Table (Business Analyst)
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
| 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
# 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.AddToolbox("C:\Program Files (x86)\ArcGIS\Desktop10.2\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
InputTable= "C:/temp/Profile.dbf"
OutPath = "C:/temp/NewProfile.xml"
# Create Profile by Import from Table
arcpy.CreateProfileByImportFromTable_ba(InputTable, "CodeFld", "CountFLD", OutPath)
# Release extension license
arcpy.CheckInExtension("Business")
except:
print arcpy.GetMessages(2)