Setting Derive Formula Options

Derive Formula nodes create a new field for each record in a data set based on the results of a CLEM expression. This expression cannot be conditional. To derive values that are based on a conditional expression, use the flag or conditional type of Derive node.

Formula Specify a formula by using the CLEM language to derive a value for the new field.

Note: Because SPSS® Modeler cannot know what submeasurement level is to be used for a derived list field, for the Collection and Geospatial measurement levels, you can click Specify... to open the Values dialog box and set the required submeasurement level. For more information, see Setting derived list values.

For Geospatial fields, the only relevant storage types are Real and Integer (the default setting is Real).