Select multiple columns (numeric, continuous) and update missing column value ("" -> "0")

[#1]

Hi,

I found the following example:

Select Multiple Columns and Update Missing Column Value [ May 28, 2019 10:21 PM (1195 views)]

and tried to modifiy it to my case, but without succes.

Column 4 to 14 (numeric, continuous) have missing values, and I would like to have "0" instead.

The script below only works for data type (character, nominal). What do I need to change to make it work for data type (numeric)?

Names Default To Here( 1 );

dt_corr = Current Data Table();

// Fill-up columns with "0", when empty.
colNames_corr = dt_corr << get column names( string );

For( i = 4, i <= N Items( colNames_corr ), i++, 
	dt_corr << select where( As Column( colNames_corr[i] ) == "" );

	If( N Rows( dt_corr << get selected rows ) > 0,
		As Column( colNames_corr[i] )[dt_corr << get selected rows] = "0"
	);
);

[#2]

Hi @PS_Ato 

try the following:

https://community.jmp.com/t5/Discussions/Replace-missing-values-with-0/td-p/64614 

https://community.jmp.com/t5/Discussions/set-value-to-selected-cells/m-p/62545/highlight/true#M33726 

let us know if they do the job.

[#3 · Accepted solution]

The script would need to be modified as such to work with numeric columns:

Names Default To Here( 1 );
dt_corr = Current Data Table();
// Fill-up columns with "0", when empty.
colNames_corr = dt_corr << get column names( string );
For( i = 4, i <= N Items( colNames_corr ), i++, 
	dt_corr << select where( is missing(As Column( colNames_corr[i] )) == 1  );
	If( N Rows( dt_corr << get selected rows ) > 0,
		As Column( colNames_corr[i] )[dt_corr << get selected rows] = 0
	);
);

[#4]

many thanks - wonderful