This is an old revision of the document!
Project parameters
Parameters can be used to parametrize transformations and expressions instead of file names in export/import transformations and instead of constants in expressions (e.g. multipliers and ratios). See expression syntax for using parameters in expressions.
Parameters are global for a project, which means that they are available for all tables. Value of a parameter is the same for all tables. Changing a parameter value doesn't automatically discard transformation results, but all new calculations will use the new value (where applicable).
Parameter editor
Parameters can be created, edited and removed using parameter editor available from menu Project or invoked by pressing F6.
Parameter types
Parameters can be of several types:
- Text or number
- File name - this parameter type is just like a text parameter but for convenience the input box has buttons for opening file browser and triggering absolute/relative paths
- Date - it's a number parameter that supposed to indicate a date that can be chosen using a date picker (calendar)
- Calculated parameter can be calculated using expressions. Such expressions can refer to another parameters (calculated or not) but not to field names as parameters are global exist on the project level. Calculated parameters are evaluated automatically before running a project or calculating a transformation.
Full project runs
All non-calculated parameters are prompted on full project runs – i.e. when running a project with all transformations not calculated (e.g. right after opening a project) or when performing Reload and Run.
Command line execution
Parameter values can be defined from command line. Defining parameters is optional. If a parameter isn't defined then its default value is used. Calculated parameters can't be defined from command line. Also new parameters can't be created from command line. See command line syntax for more details.