表中如何插入含空值的新数据
原始空表的定义 result = table(10:0, `SecurityID`BidPriceBook`AskPriceBook `BidVolumeBook`AskVolumeBook`Time, [SYMBOL,DOUBLE[], DOUBLE[], INT[], INT[], TIME])，需要添加的新数据格式
，直接用result append新表 会因为有空值报错
最佳答案 2022-11-24 12:57
用replaceColumn把AskPriceBook和AskVolumeBook转化为DOUBLE[] 再append
例
result = table(10:0, `SecurityID`BidPriceBook`AskPriceBook `BidVolumeBook`AskVolumeBook`Time, [SYMBOL,DOUBLE[], DOUBLE[], INT[], INT[], TIME]) SecurityID = string(100000) BidPriceBook = array(DOUBLE[], 0, 20).append!([1.4799 1.479 1.4787]) BidVolumeBook = array(DOUBLE[], 0, 20).append!([1.4821 1.4825 1.4828]) AskPriceBook=double() AskVolumeBook=double() Time= time(now()) tb=table(SecurityID as SecurityID ,BidPriceBook as BidPriceBook,AskPriceBook as AskPriceBook,BidVolumeBook as BidVolumeBook, AskVolumeBook as AskVolumeBook,Time as Time) //result.append!(tb)///erver response: '::append!(result, tb) => Failed to append data to column 'AskPriceBook' ' tb.replaceColumn!(`AskPriceBook,array(DOUBLE[], 0, 20).append!([take(double(),3)])) tb.replaceColumn!(`AskVolumeBook,array(DOUBLE[], 0, 20).append!([take(double(),3)])) result.append!(tb)
