find is missing start from column X till ncol()

dadawasozo — Mon, 07 Apr 2025 22:51:20 GMT

Hi,

I have a table that has thousand of columns. I want to use column matrix to find if across a range of columns is missing.

I first identify the starting of the first column number using Loc().

allcol = dt << get column names(string);

colname = column ("starting column") << getname;

colnumber = (Loc(allcol ,colname))[1];

then I want to find if the columns from colnumber till ncol() is missing. something like below but it failed. can someone point me how I can make it right ?

dt << select where (ismissing(column()[colnumber :: ncol()]))

Re: find is missing start from column X till ncol()

txnelson — Tue, 08 Apr 2025 01:34:43 GMT

Here is an example of finding rows that have missing values within a range of columns for each row.

Names Default To Here( 1 );
dt = 
// Open Data Table: semiconductor capability.jmp
// → Data Table( "semiconductor capability" )
Open( "$SAMPLE_DATA/semiconductor capability.jmp" );
// for example purposes set some random cells to missing values
For( i = 1, i <= Random Integer( 1, 100 ), i++,
	random row = Random Integer( 1, 1455 );
	random col = Random Integer( 5, 132 );
	dt[random row, random col] = .;
);

starting colName = "NPN1";
allcol = dt << get column names( string );
starting col = Contains( allcol, starting colName );
rowsWithMissing = [];

For Each Row(
	mat = dt[Row(), starting col :: N Col( dt )];
	If( Length( Loc( mat, . ) ) > 0,
		rowsWithMissing = rowsWithMissing || matrix(row());
	);
);
show(rowsWithMissing);

topic find is missing start from column X till ncol() in Discussions

find is missing start from column X till ncol()

Re: find is missing start from column X till ncol()