217828_zh-CN

liliconcom

通过脚本添加多列

你好，

我想在定义的数据表上添加多个列。 如果列已经存在，那么脚本可以忽略该列并继续添加其余的列，如果不存在直到实现。

我在这里写了一个脚本。 但问题是即使列存在，脚本仍然在数据表中添加重复的列。 你能帮忙解决这个问题吗？ 欣赏它！

Names Default To Here( 1 );
dt0 = Current Data Table();


tnames = dt0 << Get Column Names;
n = N Items( tnames );


For( i = 1, i <= n, i++,
 If( (tnames[i] ==  Char("CpK<1.0") ),
  judA = 0,
  judA=1
 );
 If( (tnames[i] == Char("1.0<=CpK <1.33") ),
  judB = 0,
  judA=1
 );
 If( (tnames[i] == Char("1.33<=CpK<1.67") ),
  judC = 0,
  judC=1
 );
 If( (tnames[i] ==  Char("1.67<=CpK<2.0") ),
  judD = 0,
  judD=1
 );
 If( (tnames[i] == Char("CpK>=2.0") ),
  judE = 0,
  judE=1
 );
);

If( judA == 1,
 dt0 << New Column( "CpK<1.0", numeric, formula( If( :Cpk < 1, 1, 0 ) ), EvalFormula ),
);
If( judB == 1,
 dt0 << New Column( "1.0<=CpK <1.33", numeric, formula( If( 1 <= :Cpk < 1.33, 1, 0 ) ), EvalFormula ),
);
If( judC == 1,
 dt0 << New Column( "1.33<=CpK<1.67", numeric, formula( If( 1.33 <= :Cpk < 1.67, 1, 0 ) ), EvalFormula ),
);
If( judD == 1,
 dt0 << New Column( "1.67<=CpK<2.0", numeric, formula( If( 1.67 <= :Cpk < 2, 1, 0 ) ), EvalFormula ),
);
If( judE == 1,
 dt0 << New Column( "CpK>=2.0", numeric, formula( If( :Cpk >= 2, 1, 0 ) ), EvalFormula ),
);

Re: 通过脚本添加多列

非常感谢，文斯！有用。

Re: 通过脚本添加多列

你可以做这样的事情。

 

Names default to here(1);
dt = open("$SAMPLE_DATA\Big Class.jmp");
dt << New Column("Cpk", Set Each Value(random normal(1, 1)));
dt << New Column("1.0<=CpK <1.33", Set Each Value(0));

col_names = dt << Get column names(string); // this is your existing columns

//I would just do a not contains which checks where an item is in a list, returning 0 if it doesn't
if(!Contains(col_names, "CpK<1.0"), 
 dt << New Column( "CpK<1.0", numeric, 
  formula( 
   // you also don't have to do the if(thing, 1, 0) :Cpk < 1 will resolve to 1 and 0 anyway
   :Cpk < 1
  )
 )
);
// this one shouldn't get remade
if(!Contains(col_names, "1.0<=CpK <1.33"), 
 dt << New Column( "1.0<=CpK <1.33", numeric, formula( 1.0<=:Cpk <1.33 ))
);

if(!Contains(col_names, "1.33<=CpK<1.67"), 
 dt << New Column( "1.33<=CpK<1.67", numeric, formula( 1.33<=:Cpk <1.67 ))
);

if(!Contains(col_names, "1.67<=CpK<2.0"), 
 dt << New Column( "1.67<=CpK<2.0", numeric, formula( 1.67<=:Cpk <2 ))
);

if(!Contains(col_names, "CpK>=2.0"), 
 dt << New Column( "CpK>=2.0", numeric, formula( 2.0<=:Cpk ))
);

您还可以对其进行一些抽象，这样您就可以只更改 1 个数据结构，它会更改您的字段。  

//But I would probably do it another way
Names default to here(1);
dt = open("$SAMPLE_DATA\Big Class.jmp");
dt << New Column("Cpk", Set Each Value(random normal(1, 1)));
dt << New Column("1<=Cpk<1.33", Set Each Value(0));
col_names = dt << Get column names(string); // this is your existing columns

//I'd make a 2 col matrix with low and high check then make the columns dynamically
cpk_check = [. 1, 1 1.33, 1.33 1.67, 1.67 2, 2 .];
for(i=1, i<=nrows(cpk_check), i++, 
 low = cpk_check[i, 1];
 high = cpk_check[i, 2];

 if(!ismissing(low), 
  if(!ismissing(high), 
   col_name = char(low) || "<=Cpk<" ||char(high);
   f = EvalExpr(Expr(low)<=:Cpk<EXPR></EXPR>

 

Re: 通过脚本添加多列谢谢蒂埃里！ 那么如何解决这个问题呢？Re: 通过脚本添加多列你好，
问题出在你的 5 个开关 judA - judE 为每一列重新评估的循环中。 因此，当您浏览完 n 个现有列时，所有开关的状态都将设置为最后一列。