496132_zh-CN

liliconcom

行操作

For(x=1,x<=N Rows(dt),x++,
  If(IsMissing(Column(  dt, "Actual Finish Date_" )[x]),
  Column(  dt, "bouge pas" )[x] = Column(  dt, "Operation Due Date_" )[x] - :Operation Start Date_ [x-1], 
  Column(  dt, "bouge pas" )[x] = Column(  dt, "Actual Finish Date_" )[x] - :Actual Execution Start Date_ [x]
  );
  
 );

您好，我的问题是我想在 for 的第一行，列 x-1 的行：Operation Start Date_ 但是这种语法不起作用？ 谢谢

脚本回复：行操作

如果您正在遍历数据表的行（通常我会尽量避免它并使用公式或设置每个值）我建议使用 For Each Row() 而不是 For()。 如果没有示例数据，我猜问题可能是您将获得 0 作为行号，这在 JMP 中无效（访问或评估 ':Operation Start Date_[ /*###*/x - 1]' , :Operation Start Date_[/*###*/x - 1] 时，第 2 行的行号无效)

尝试手动设置 x 值并查看您得到的结果，添加调试打印并查看日志

 

这是示例脚本，其中包含一些关于如何设置 bouge pas 列值的可选想法

Names Default To Here(1);

dt = New Table("Untitled",
 Add Rows(3),
 New Column("Actual Finish Date_", Numeric, "Continuous", Format("Best", 12), Set Values([1, 4, 6])),
 New Column("Actual Execution Start Date_", Numeric, "Continuous", Format("Best", 12), Set Values([0, 2, 3])),
 New Column("Operation Start Date_", Numeric, "Continuous", Format("Best", 12), Set Values([10, 21, 32])),
 New Column("Operation Due Date_", Numeric, "Continuous", Format("Best", 12), Set Values([11, 22, 33])),
 New Column("bouge pas", Numeric, "Continuous")
);

For(x = 1, x <= N Rows(dt), x++,
 If(Is Missing(Column(dt, "Actual Finish Date_")[x]),
  Column(dt, "bouge pas")[x] = Column(dt, "Operation Due Date_")[x] - :Operation Start Date_[x - 1],
  Column(dt, "bouge pas")[x] = Column(dt, "Actual Finish Date_")[x] - :Actual Execution Start Date_[x]
 );
);

/* better option in my opinion
For Each Row(dt,
 If(Is Missing(:"Actual Finish Date_"n),
  :"bouge pas"n = :"Operation Due Date_"n - :Operation Start Date_[Row() - 1],
  "bouge pas"n = :"Actual Finish Date_"n - :Actual Execution Start Date_
 );
);
*/

/* usually best option 
Column(dt, "bouge pas") << Set Each Value(
 If(Is Missing(:"Actual Finish Date_"n),
  :"Operation Due Date_"n - :Operation Start Date_[Row() - 1],
  :"Actual Finish Date_"n - :Actual Execution Start Date_
 );
);
*/