joinx 函数报错 null
B18 传值的具体内容是:
C17.joinx@i(2c9a02e1783b5e3701785de4766a2e29,C14,2c9a02e1783b5e370178913dd50c1112,2c9a02e1783b5e370178913dab1a1105)
运行脚本抱错
SEVERE: com.scudata.common.RQException: 单元格 B18 中有错误
null
com.scudata.common.RQException: 单元格 B18 中有错误
null
at com.scudata.cellset.datamodel.PgmCellSet.$1(Unknown Source:2053)
at com.scudata.cellset.datamodel.PgmCellSet.run(Unknown Source:2100)
at com.scudata.ide.spl.SheetSpl.runCellSet(SheetSpl.java:1387)
at com.scudata.ide.spl.SheetSpl$RunThread.run(SheetSpl.java:1638)
Caused by: java.lang.NullPointerException
at com.scudata.expression.mfn.cursor.Joinx.$1(Unknown Source:181)
at com.scudata.expression.mfn.cursor.Joinx.getJoinxCursor(Unknown Source:199)
at com.scudata.expression.mfn.cursor.Joinx.calculate(Unknown Source:142)
at com.scudata.expression.operator.DotOperator.calculate(Unknown Source:86)
at com.scudata.expression.Expression.calculate(Unknown Source:160)
at com.scudata.cellset.datamodel.PgmNormalCell.calculate(Unknown Source:159)
at com.scudata.cellset.datamodel.PgmCellSet._$1(Unknown Source:1965)
… 3 more
维表数据结果如下图:
集算器版本:
字段名是数字开头?
大维表通常要是个文件,它会来回反复读,不能用游标。全有序才能是游标。
C17.joinx@i 时维表不能是游标。
带 @m 时,维表是可以是游标,但这是归并。
C17.joinx@i 时维表修改成了组表,不使用游标了。但是还是报错 null
[2023-08-18 17:41:22]
SEVERE: com.scudata.common.RQException: 单元格 B18 中有错误
null
com.scudata.common.RQException: 单元格 B18 中有错误
null
at com.scudata.cellset.datamodel.PgmCellSet.$1(Unknown Source:2053)
at com.scudata.cellset.datamodel.PgmCellSet.run(Unknown Source:2100)
at com.scudata.ide.spl.SheetSpl.runCellSet(SheetSpl.java:1387)
at com.scudata.ide.spl.SheetSpl$RunThread.run(SheetSpl.java:1638)
Caused by: java.lang.NullPointerException
at com.scudata.expression.mfn.cursor.Joinx.$1(Unknown Source:181)
at com.scudata.expression.mfn.cursor.Joinx.getJoinxCursor(Unknown Source:199)
at com.scudata.expression.mfn.cursor.Joinx.calculate(Unknown Source:142)
at com.scudata.expression.operator.DotOperator.calculate(Unknown Source:86)
at com.scudata.expression.Expression.calculate(Unknown Source:160)
at com.scudata.cellset.datamodel.PgmNormalCell.calculate(Unknown Source:159)
at com.scudata.cellset.datamodel.PgmCellSet._$1(Unknown Source:1965)
… 3 more