cols=[`a,`f,`b,`c,`d,`e] tb=table(rand(1.0,10) as a,rand(10.0,10) as d,rand(100.0,10) as c ) for (icol in (set(cols)-set(colNames(tb))).keys()){ tb[icol]=double() } reorderColumns!(tb,cols) m=matrix(tb).rename!(cols)
示例代码:
t = table(2022.07.04T09:45:00 2022.07.04T09:45:00 2022.07.04T09:45:00 2022.07.04T09:45:00 as time, `A`B`C`D as sym, 1.0 2.0 3.0 4.0 as value) syms = `A`B`C`D`E`F symsTmp = syms[not syms in (exec sym from t)] insert into t(sym) values(symsTmp) select value from t pivot by time, sym