Overview
The unpivot operation allows a user to turn table columns into table rows. The common order of operations will be to first collect the data, then unpivot the data, and finally query the data.
Unpivot Example
Source Table
Account |
Department |
Jan 2020 |
Feb 2020 |
March 2020 |
---|---|---|---|---|
1000 |
Retail |
$500 |
$400 |
$600 |
2000 |
Service |
$1000 |
$2000 |
$3000 |
Account |
Department |
Date |
Amount |
---|---|---|---|
1000 |
Retail |
Jan 2020 |
$500 |
Field |
Required/ Optional |
Comments |
---|---|---|
Name |
Required |
Must enter name of unpivot. This can be any name of preference. |
Description |
Optional |
Optional. Descriptive free-text name for the collector |
History Retention (Days) |
Optional |
Optional. Default is set as zero. |
Source Data Source |
Optional |
Optional. Select from the dropdown menu provided. |
Source Schema |
Required |
Must enter Source Schema. Select from the dropdown menu provided. |
Ignore Columns |
Optional |
Optional. Select from the dropdown menu provided. |
Key Column Name |
Required |
Must enter Key Column Name. |
Value Column Name |
Required |
Must enter Column Value Name. |
Target Data Source |
Required |
Must enter Target Data Source. Select from the dropdown menu provided. |
Target Schema |
Required |
Must enter Target Schema. |