496132_zh-TW

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_
 );
);
*/