For 循环 -- 删除列表中的行和公式大家好,
如何迭代删除公式,然后在列表中使用 for 循环删除列?
像这样的东西:
col_formula = {"Column1", "Column2" };
col2_row = {"Column3", "Column4"};
For( i = 1, i <= N 项 ( col_formula ), i++,
col_formula (i) << 删除公式 //删除公式
col2_row (i) << Delete Row//删除行
);
数据表其他Re: For 循环 -- 删除列表中的行和公式你好
我认为这应该可以工作,但您的列格式可能不正确。
cols={":col_1",":col_2"};<BR />Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Bank Loan.jmp" );
:Time << Delete Formula;
Re: For 循环 -- 删除列表中的行和公式col_formula = {"Column1", "Column2"};
col2_row = {"Column3", "Column4"};
// This will delete the formula
For( i = 1, i <= N Items( col_formula ), i++,
Column( col_formula[i] ) << Delete Formula; //delete formula
);
// You cannot delete a row within a given column. JMP always has
// an equal number of rows for all columns.
// You can delete a row, but it will delete the row for all columns.
current data table() << delete rows( i );
// If you want to remove the value for a given row within a column,
// you can set the value to a missing value