Import Statistical Data Collection parameters

Disponible con licencia de 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_2022 and SALES_Q2_2022, and you want to add a calculated variable that will sum these, your spreadsheet should include the following three rows:

    VARIABLEALIASSUMMARYTYPEFORMULA

    SALES_Q1_2022

    Sales Q1 2022

    Sum

    SALES_Q1_2022

    Sales Q1 2022

    Sum

    SALES_H1_2022

    Sales H1 2022

    Script

    !SALES_Q1_2022! + !SALES_Q1_2022!

  • For Averages, use Summary Type = Avg:
    Nota:

    The Average variable must include WEIGHTFIELD.

    VARIABLEALIASSUMMARYTYPEWEIGHTFIELD

    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:

    ParameterField name

    Variable Name

    VARIABLE

    Category

    CATEGORY

    Alias

    ALIAS

    Summary Type

    SUMMARYTYPE

    Apportionment Method

    BASETYPE

    Decimals

    DECIMALS

    Script/Formula

    FORMULA

    Weight

    WEIGHTFIELD

Temas relacionados