Versions Compared

Old Version 2

changes.mady.by.user Anand Vedam

Saved on

compared with

New Version Current

changes.mady.by.user Anand Vedam

Saved on

Key

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

In this article

Child pages (Children Display)toc
depthmaxLevel2
absoluteUrltrue

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

Supported ExpressionsOfficial Docs for Reference 

  • CASE

  • COALESCE

  • NULLIF

...