Import Statistical Data Collection parameters

获得 Business Analyst 许可后可用。

Importing parameters from a table allows you to assign values for multiple custom data variables and properties simultaneously. The variable properties can be stored in an Excel spreadsheet, or any other tabular format, and used for multiple statistical data collections. It is recommended that Excel tables be used for setting up the parameters based on the simplicity of editing multiple rows at once. A single Excel workbook file can have multiple spreadsheets in it, and each spreadsheet can be shown as a separate table on the Import Parameters dialog box.

The following steps guide you through importing parameters from a table for use in Statistical Data Collections.

1. In the ArcGIS Pro Catalog pane, right-click your Statistical Data Collection and click Edit.

   The Statistical Data Collection dialog box appears.

2. If it's not already highlighted, click Variables in the left pane of the editor.

   Variable parameters and their values are displayed in table format.

3. Click the Import Parameters button in the lower right of the editor.
4. Navigate to your table, select it, and click OK.

   Values from the imported table populate the respective parameter columns.

Requirements for the parameters table

The requirements for the parameters table are as follows:

• Each parameters table must have a column named VARIABLE. This column identifies the variable receiving parameter settings. Values in the VARIABLE column must be unique.
• For regular statistical data collection variables, the value in the VARIABLE column must exist. For calculated variables, the value will be created and added to the bottom of the list, if missing. For example, if your statistical data collection variable already contains variables named SALES_Q1_2020 and SALES_Q2_2020, and you want to add a calculated variable that will sum these, your spreadsheet should include the following three rows:

  VARIABLE	ALIAS	SUMMARYTYPE	FORMULA
  SALES_Q1_2020	Sales Q1 2020	Sum
  SALES_Q1_2020	Sales Q1 2020	Sum
  SALES_H1_2020	Sales H1 2020	Script	!SALES_Q1_2020! + !SALES_Q1_2020!

• For Averages, use Summary Type = Avg:

  注：

  The Average variable must include WEIGHTFIELD.

  VARIABLE	ALIAS	SUMMARYTYPE	WEIGHTFIELD
  TOT_CUSTOMERS	Total Customers	SUM
  AVG_SALES	Average Sales per customer	Avg	TOT_CUSTOMERS

• The other properties that can be set via the parameters table, with corresponding field names, are listed below:

  Parameter	Field name
  Variable Name	VARIABLE
  Category	CATEGORY
  Alias	ALIAS
  Summary Type	SUMMARYTYPE
  Apportionment Method	BASETYPE
  Decimals	DECIMALS
  Script/Formula	FORMULA
  Weight	WEIGHTFIELD