The function outputs the contents of the input column in dense format in the output columns value_temp and value_pressure, which contain the temperature and pressure, respectively. Because these values are numeric, the function casts them to VARCHAR.
sn | city | week | value_pressure | value_temp |
---|---|---|---|---|
1 | Asheville | 1 | 1020.8 | 32 |
2 | Asheville | 2 | 1021.3 | 32 |
3 | Asheville | 3 | 1021.7 | 34 |
4 | Nashville | 1 | 1021 | 42 |
5 | Nashville | 2 | 1019.8 | 44 |
6 | Brownsville | 2 | 1019 | 47 |
7 | Brownsville | 3 | 1019.2 | 46 |