Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this article

all
Child pages (Children Display)
Table of Contents
2
maxLevel2
absoluteUrltruedepth

Overview

You can use the following expressions with the Expression symbol = enabled, where available, to define the field values in ELT Snaps and accounts. In addition to the list provided below, you can always use the scalar value SQL functions and expressions that your target cloud data warehouse (CDW) supports.

Warning
titleELT Snaps Vs. Standard-Mode Snaps

In the ELT Snaps

Do not use , DO NOT:

  • Use regular JavaScript expressions (supported in the Standard-mode Snaps) that are not listed here.
 
Do not prefix
  • Prefix the variable names with $ symbol.

Conditional Expressions

Math Functions

Supported Functions    Official Docs for Reference 
  • ABS

  • ACOS

  • ASIN

  • ATAN

  • ATAN2

  • COS

  • EXP

  • FLOOR

  • LOG

  • POWER

  • ROUND

  • SIN

  • SIGN

  • SQRT

  • TAN

String Functions

Supported Functions     Official Docs for Reference 
  • CONCAT

  • LOWER

  • LTRIM

  • REPLACE

  • REVERSE

  • RTRIM

  • SUBSTRING

  • TRANSLATE

  • TRIM

  • UPPER

...