Versions Compared

Key

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

...

Multiexcerpt include macro
nameME_ELT_KI_Underscore_Refs
pageELT Snap Pack

Snap Input and Output

Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
Input 

Document

  • Min: 1
  • Max: 1
  • ELT Transform
  • ELT Select
  • ELT Copy
  • ELT Filter
The SQL query in which you want to add the PIVOT function. Typically, it would be a SELECT query reading the source table. 
Output

Document

  • Min: 1
  • Max: 1
  • ELT Insert-Select
  • ELT Transform
  • ELT Unique

The incoming SQL query with the PIVOT function.

Snap Settings

Info
titleSQL Functions and Expressions for ELT

You can use the SQL Expressions and Functions supported for ELT to define your Snap or Account settings with the Expression symbol = enabled, where available. This list is common to all target CDWs supported. You can also use other expressions/functions that your target CDW supports.


Parameter NameData TypeDescriptionDefault ValueExample 
LabelString
Excerpt Include
File Writer
File Writer
nopaneltrue
ELT PivotPivot Student Data
Get preview dataCheck box
Multiexcerpt include macro
namegetpreviewdata
pageELT Intersect
Not selectedSelected
Aggregate FunctionString

Select the aggregate function that to apply to the pivot column.

Available options are:

  • AVG
  • COUNT
  • MAX
  • MIN
  • SUM
AVGSUM
Pivot ColumnStringRequired. Specify the column in the source table upon which to apply the aggregate functions. N/AORDER_AMOUNT
Value ColumnStringRequired. Specify the column for whose to calculate the aggregate on the pivot columns.N/AAGENT_CODE
Pivot Value List

Required. This field set enables you to specify the values in the Value Column for which you want to see the aggregated values. Specify each value in a separate row. Click + to add a new row.

This field set consists of the following field:

  • Pivot Value
Pivot ValueStringRequired. Enter the list of unique values in the Value Column to include in the output. The column contains null values if the specified value here does not have any records in the input table.N/A

A002

A004

...