Reference Manual
- Foreword
- Introduction
- Overwiew of the language and conventions
- Introduction
- Conventions for writing VTL Transformations
- Typographical conventions
- Abbreviations for the names of the artefacts
- Conventions for describing the operators’ syntax
- Description of data types of operands and result
- VTL-ML Operators
- VTL-ML - Evaluation order of the Operators
- Description of VTL Operators
- VTL-DL - Rulesets
- VTL-DL – User Defined Operators
- VTL-ML - Typical behaviours of the ML Operators
- Typical behaviour of most ML Operators
- Operators applicable on one Scalar Value or Data Set or Data Set Component
- Operators applicable on two Scalar Values or Data Sets or Data Set Components
- Operators applicable on more than two Scalar Values or Data Set Components
- Behaviour of Boolean operators
- Behaviour of Set operators
- Behaviour of Time operators
- Operators changing the data type
- Type Conversion and Formatting Mask
- Attribute propagation
- Operators
- VTL-ML - General Purpose Operators
- VTL-ML - Join operators
- VTL-ML - String Operators
- VTL-ML - Numeric Operators
- VTL-ML - Comparison Operators
- VTL-ML - Boolean Operators
- VTL-ML - Time Operators
- Period indicator: period_indicator
- Fill time series: fill_time_series
- Flow to stock: flow_to_stock
- Stock to flow: stock_to_flow
- Time shift: timeshift
- Time aggregation: time_agg
- Actual time: current_date
- Days between two dates: datediff
- Add a time unit to a dete: dateadd
- Extract time period from a date: year, month, dayofmonth, dayofyear
- Number of days to duration: daytoyear, daytomonth
- Duration to number of days: yeartoday, monthtoday
- VTL-ML - Set Operators
- VTL-ML - Hierarchical aggregation
- VTL-ML - Aggregate and Analytic operators
- Aggregate invocation
- Analytic invocation
- Counting the number of data points: count
- Minimun value: min
- Maximum value: max
- Median value: median
- Sum: sum
- Average value: avg
- Population standard deviation: stddev_pop
- Sample standard deviation: stddev_samp
- Population variance: var_pop
- Sample variance: var_samp
- First value: first_value
- Last value: last_value
- Lag: lag
- Lead: lead
- Rank: rank
- Ratio to report: ratio_to_report
- VTL-ML - Data Validation Operators
- VTL-ML - Conditional Operators
- VTL-ML - Clause Operators