Unpivots
- 1 Overview
- 1.1 Unpivot Example
- 2 Configuration
- 2.1 Details
- 2.2 Latest Execution
- 2.2.1 Logs
- 2.3 Executions
- 3 Saved Views
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 |
Unpivoted table
Account | Department | Date | Amount |
|---|---|---|---|
1000 | Retail | Jan 2020 | $500 |
Configuration
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. |
Details
The details section documents who the unpivot was created and updated by and the corresponding times. This allows for easy tracking of multiple unpivots.
Latest Execution
The latest execution section documents the state of the unpivot, created time, and status of the unpivot. States include complete and error.
Logs
Job logs are easily accessible via the state link in the Latest Execution section. Click the linked state and the user is taken to the Executions section. Here users view items, details and logs related to the ran job. Logs are downloadable via the download log button indicated at the top right of the log section. Logs are useful to see how much data was collected, the steps taken, and the time in which it occurred.
Executions
The executions section documents when the unpivot was created, started, completed and the total amount of data scanned. The status includes information regarding the state of the unpivot. This allows for easy tracking of multiple unpivots.
Saved Views
Saved views are a unique feature offered by DataBlend that allow users to quickly view filtered searches. Setting a saved view is simple. Click the gear icon in the upper right corner. A drop-down will appear with option to save the current view, restore the default view, or copy share URL. Copying a Share URL will allow other users with the URL to view the same saved view.
Want to see more? Visit our helpful demo page or attend an office hour. https://lp.datablend.com/demos