524928_zh-CN

liliconcom

如何在制表中使用列列表作为分析列？

我遇到了一个问题，我想将大型测试程序中每个测试的总和和 n 制成表格。 我不确定我的问题是什么，但希望得到一些指导。 代码编译并输出 Tabulate 窗口，如下所示，但未填充。

 

下面是我写的代码：

 

dt = Current Data Table();
colList = dt << Get Column Names( string );
colname = Column(dt, "TEST_T") << getname;
testIndex = (Loc(colList, colname))[1];
numRows = N Rows(dt);

For(i = (testIndex + 1), i <= N Items(colList), i++,
 column = Column(dt, colList[i]);
 For(j = 1, j <= numRows, j++,
  column[j] = Substitute(column[j], 
   "Pass", "1",
   "Fail", "0"
  );  
 );
);

//Change Modeling Type for Tabulate functionality
dt:tst_temp << Set Modeling Type(Nominal);
dt:SITE_NUM << Set Modeling Type(Nominal);

////Change Every Column after TEST_T to Numeric Data Type and Continuous Modeling type
For(i = (testIndex + 1), i <= N Items(colList), i++,
 column = Column(dt, colList[i]);
 column << Data Type(Numeric);
 column << Set Modeling Type(Continuous);
);

list = dt << Get Column Names( string );
Remove From(list, 1, testIndex);

yieldByTest = (dt << Tabulate(
  Add Table(
   Column Table(
    Grouping Columns(:tst_temp),
    Statisitcs(Sum, N)
   ),
   Row Table(
    Analysis Columns(Column(Eval(list)))
   )
  ),invisible
 )
) << Make Into data Table;
yieldByTest << Set Name("Yield by Test Across Temperature");

 

分析数据表图形脚本视窗