|Multiexcerpt include macro|
Snap Input and Output
|Input/Output||Type of View||Number of Views||Examples of Upstream and Downstream Snaps||Description|
|The SQL query in which you want to add the PIVOT function. Typically, it would be a SELECT query reading the source table.|
The incoming SQL query with the PIVOT function.
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 Name||Data Type||Description||Default Value||Example|
|ELT Pivot||Pivot Student Data|
|Get preview data||Check box|
Select the aggregate function that to apply to the pivot column.
Available options are:
|Pivot Column||String||Required. Specify the column in the source table upon which to apply the aggregate functions.||N/A||ORDER_AMOUNT|
|Value Column||String||Required. Specify the column for whose to calculate the aggregate on the pivot columns.||N/A||AGENT_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||String||Required. 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|