546421_es-ES

liliconcom

For loop: eliminar fila y fórmula en la lista

Hola a todos,

¿Cómo puedo iterar una fórmula de eliminación y luego eliminar una columna usando un bucle en la lista?

Algo como esto:

 

col_formula = {"Columna1", "Columna2" };

columna2_fila = {"Columna3", "Columna4"};

 

For( i = 1, i <= N Elementos ( col_formula ), i++,
col_formula (i) << Eliminar fórmula //eliminar fórmula

col2_fila (i) << Eliminar fila//eliminar fila
);

Tabla de datosOtroRe: Bucle for: eliminar fila y fórmula en la lista

Hola

Creo que esto debería funcionar, espero que el formato de su columna sea incorrecto.

cols={":col_1",":col_2"};<BR />

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Bank Loan.jmp" );
:Time << Delete Formula;

Re: Bucle for: eliminar fila y fórmula en la lista

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