Query results CSV file - columns ordering by parameters NAME, DEPTH and AGGREGATION (Avg, Smp, Min, Max & StdDev)
-
About the query results in the CSV file, I have a request if it is possible to implement it: In the file, the parameters columns are ordered by Stations and this is ok, but inside the same station all the parameters are not in order. After the stations ordering it could be possible automatically order the columns by parameters name (string without depth "xx" and aggregation "yyy" chars), then order by depth (if present) and finally by aggregation, if possible in the following order (Avg, Smp, Min, Max & StdDev)? This could be in general much useful to avoid confusion, especially downloading Soil water content, soil water potential and soil temperature where we can have many similar parameters, where change just the depth, or the plot; to manage this, in excel is almost mandatory manually order the columns.
Example (here miss only the aggregation ordering)
RIGHT NOW:
b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 |
---|---|---|---|---|---|---|---|---|---|---|---|
st_b | st_b | st_b | st_b_00 | swc_st_a | swc_st_a | swc_st_a | swc_st_a | swc_st_b | swc_st_b | swc_st_b | st_b |
50 | 20 | 10 | 50 | 2 | 5 | 20 | 2 | 5 | 20 | 5 |
ORDERED:
b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 | b2 |
---|---|---|---|---|---|---|---|---|---|---|---|
st_b_00 | st_b | st_b | st_b | st_b | swc_st_a | swc_st_a | swc_st_a | swc_st_a | swc_st_b | swc_st_b | swc_st_b |
5 | 10 | 20 | 50 | 2 | 5 | 20 | 50 | 2 | 5 | 20 |
-
still miss the "00" depth indication in the downloaded file ("st_b_00" parameter)
Edited by Zandonai Alessandro