The input table contains temperature, pressure, and dewpoint data for three cities, in dense (pivoted) format.
| Input Table Column Name |
Data Type |
| sn |
INTEGER |
| city |
VARCHAR |
| week |
INTEGER |
| temp |
INTEGER |
| pressure |
DOUBLE PRECISION |
| dewpoint |
VARCHAR |
Unpivot Examples Input Table unpivot_input
| sn |
city |
week |
temp |
pressure |
dewpoint |
| 1 |
Asheville |
1 |
32 |
1020.8 |
27.6F |
| 2 |
Asheville |
2 |
32 |
1021.3 |
27.4F |
| 3 |
Asheville |
3 |
34 |
1021.7 |
28.2F |
| 4 |
Nashville |
1 |
42 |
1021 |
29.4F |
| 5 |
Nashville |
2 |
44 |
1019.8 |
29.2F |
| 6 |
Brownsville |
2 |
47 |
1019 |
28.9F |
| 7 |
Brownsville |
3 |
46 |
1019.2 |
28.9F |