topic Re: How to script changing column data type to Numeric when the rows are a mix of string and numbers in Discussions

How to script changing column data type to Numeric when the rows are a mix of string and numbers

user8421 — Sat, 10 Jun 2023 23:14:50 GMT

I have a data column where some rows are string and some rows are numbers. When I manually convert the Data Type from Character to Numeric, the strings disappear leaving only the text rows. This is the exact result I would like to replicate via JSL. However when I run a script that performs the same functions it does not change the Data Type for the column.

Attached is a screen recording showing both the script not acting on the column and the manual process of changing the Data Type with desired result.

(view in My Videos)

Re: How to script changing column data type to Numeric when the rows are a mix of string and numbers

Mark_Bailey — Wed, 17 Jun 2020 18:22:42 GMT

This example shows how to do it.

Names Default to Here( 1 );

dt  = Open( "$SAMPLE_DATA/Big Class.jmp" );

test = dt << New Column( "Test", Character, Nominal,
	Values({
		"Mark",
		"Jane",
		"5.37",
		"3.14",
		"Linda",
		"1.732"
	})
);

Wait( 2 );

test << Set Data Type( Numeric );

Re: How to script changing column data type to Numeric when the rows are a mix of string and numbers

txnelson — Wed, 17 Jun 2020 18:23:30 GMT

Your JSL syntax is incorrect. It should be:

dt=current data table();
dt:example << data type(numeric)<<format("Best", 12) <<
modeling type(continuous);