In this Page
Table of Contents | ||||
---|---|---|---|---|
|
Scenario
I want to pivot data that is coming in before I use it further downstream.
Requirements
Snaps Used
For this scenario, the following Snaps are used:
- JSON Generator or a File Reader
- Script
Other Requirements
- A file or the content for the JSON Generator.
Configuration
This example will bring in data using the JSON Generator.
...
This script will process the data from the JSON Generator Snap and deliver it as:
monthkey | key | value |
Month01 | 001 | 151 |
Month02 | 001 | 152 |
Month03 | 001 | 153 |
Month04 | 001 | 154 |
Month05 | 001 | 155 |
Month06 | 001 | 156 |
Month07 | 001 | 157 |
Month08 | 001 | 158 |
Month09 | 001 | 159 |
Month10 | 001 | 160 |
Month11 | 001 | 161 |
Month12 | 001 | 162 |
...