Label | Explanation | Data Type |
Input Table
| The dataset that the new rule will be applied to. | Table View |
Output Folder
| The folder where the output .csv file will be saved. The name of the file will be taken from the Input Table parameter value. | Folder |
Field
| The name of the existing field the rule will be applied to. | Field |
Expression
(Optional) | An SQL expression that limits the rows that the attribute rule will be applied to. | SQL Expression |
Create Sequences
(Optional) | Specifies whether database sequences will be created in the specified workspace.
| Boolean |
Definition Type
(Optional) | Specifies the method that will be used to define the format of the ID.
| String |
ID Builder
(Optional) | A set of format options that will define the attribute rule. This includes an SQL expression that will be used to apply different formats and sequences per asset, as well as padding, prefix, and suffix values.
A preview of the string will display in the Geoprocessing pane from the values entered in the format options. | Value Table |
ID Definition Table
(Optional) | A table or record set that defines the ID format. This includes the SQL expression that will be used to apply different formats and sequences per asset, as well as padding, prefix, and suffix values. The table must include the following fields:
| Record Set |
Coded Value Fields
(Optional) | The fields that will be used to generate an SQL expression and configuration for an ID. | Field |
Derived Output
Label | Explanation | Data Type |
Output Rule CSV | The output .csv file containing an Arcade attribute rule based on the inputs provided. This file is used to import the attribute rule to the dataset. | File |
ID Definition Table | A table of the sequence definition configurations. This file can be edited and reused by the tool using the Definition Type parameter's Table option. | File |
Python Sequence Script | The output Python sequence file. The file can be used in other workspaces or by anyone with permissions to create database sequences. | File |