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 |