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. |
Latest Run
The latest run section documents the state of the unpivot, created time, and the status of the query. States include complete and error. When to a current stream (i.e. the data collected yesterday vs the data collected today). This can be found by hovering over the lasted run created text. Job logs are easily accessible via the latest run section at the top of the page. Click the linked timestamp and the user is taken to the job details.
Want to see more? Visit our helpful demo page or attend an office hour. Demos