Operators

• VTL-ML - General Purpose Operators
  • Parentheses: ()
  • Persistent assignment: <-
  • Non-persistent assignment: :=`
  • Membership: #
  • User-defined operator call
  • Evaluation of an external routine: eval
  • Type conversion: cast
• VTL-ML - Join operators
  • Join: inner_join, left_join, full_join, cross_join
• VTL-ML - String Operators
  • String concatenation: \
  • Whitespace removal: trim, rtrim, ltrim
  • Character case conversion: upper/lower
  • Sub-string extraction: substr
  • String pattern replacement: replace
  • String pattern location: instr
  • String length: length
• VTL-ML - Numeric Operators
  • Unary Plus: +
  • Unary Minus: -
  • Addition: +
  • Subtraction: -
  • Multiplication: *
  • Division: /
  • Modulo: mod
  • Rounding: round
  • Truncation: trunc
  • Ceiling: ceil
  • Floor: floor
  • Absolute value: abs
  • Exponential: exp
  • Natural logarithm: ln
  • Power: power
  • Logarithm: log
  • Square root: sqrt
  • Random: random
• VTL-ML - Comparison Operators
  • Equal to: =
  • Not equal to: <>
  • Greater than: > >=
  • Less than < <=
  • Between between
  • Element of in / not_in
  • Match characters: match_characters
  • Is null: isnull
  • Exists in: exists_in
• VTL-ML - Boolean Operators
  • Logical conjunction: and
  • Logical disjunction: or
  • Exclusive disjunction: xor
  • Logical negation: not
• 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
  • Union: union
  • Intersection: interesect
  • Set difference: setdiff
  • Symmetric difference: symdiff
• VTL-ML - Hierarchical aggregation
  • Hierarchical roll-up: hierarchy
• 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
  • Check datapoint: check_datapoint
  • Check hierarchy: check_hierarchy
  • Check : check
• VTL-ML - Conditional Operators
  • if-then-else: if
  • Case: case
  • Nvl: nvl
• VTL-ML - Clause Operators
  • Filtering Data Points: filter
  • Calculation of a Component: calc
  • Aggregation: aggr
  • Maintaining Components: keep
  • Removal of Components: drop
  • Change of Component name: rename
  • Pivoting: pivot
  • Unpivoting: unpivot
  • Subspace: sub