可以利用 parseExpr 解析 json 字符串成 DDB 的字典,然后利用字典索引取出对应数据,然后用 flip / transpose 转化成表
v = '{"rc":0,"rt":6,"svr":181669448,"lt":1,"full":1,"dlmkts":"","data":{"total":5607,"diff":[{"f2":10.71,"f12":"000001"},{"f2":7.24,"f12":"000002"}]}}'
d = parseExpr(v).eval()
each(flip, d["data"]["diff"]).unionAll(false)