Field names (automated data preparation)
To easily identify new and transformed features, ADP creates and applies basic new names, prefixes, or suffixes. You can amend these names to be more relevant to your own needs and data. If you want to specify other labels, you will need to do this in a downstream Type node.
Transformed and Constructed Fields. Specify the name extensions to be applied to transformed target and input fields.
Note that in the ADP node, setting string fields to contain nothing may cause an error depending on how you chose to handle unused fields. If How to handle fields that are excluded from modeling is set to Filter out unused fields on the Field Settings panel of the Settings tab, the name extensions for inputs and the target can be set to nothing. The original fields are filtered out and the transformed fields saved over them; in this case the new transformed fields will have the same name as your original.
However if you chose Set the direction of unused fields to ‘None’, then empty, or null, name extensions for the target and inputs will cause an error because you will be trying to create duplicate field names.
In addition, specify the prefix name to be applied to any features that are constructed via the Select and Construct settings. The new name is created by attaching a numeric suffix to this prefix root name. The format of the number depends on how many new features are derived, for example:
- 1-9 constructed features will be named: feature1 to feature9.
- 10-99 constructed features will be named: feature01 to feature99.
- 100-999 constructed features will be named: feature001 to feature999, and so on.
This ensures that the constructed features will sort in a sensible order no matter how many there are.
Durations Computed from Dates and Times. Specify the name extensions to be applied to durations computed from both dates and times.
Cyclical Elements Extracted from Dates and Times. Specify the name extensions to be applied to cyclical elements extracted from both dates and times.