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 |