先将matrix转换成表,然后unpivot处理,参考如下代码:
//pane data n = 7 label = 2023.01.03 + 0..6 SH600000 = rand(4.0, n)//$DECIMAL64(3) SH600004 = rand(14.0, n)//$DECIMAL64(3) SH600006 = rand(114.0, n)//$DECIMAL64(3) p = table(label, SH600000, SH600004, SH600006) p = matrix(SH600000, SH600004, SH600006) p.rename!(label, `SH600000`SH600004`SH600006) t = table(p.rowNames() as label, p) // unpivot f = t.unpivot(`label, `SH600000`SH600006`SH600004, first) select * from f order by label, valueType