topic How to change column data type from Numeric to Character? in Discussions

How to change column data type from Numeric to Character?

ariel — Sat, 30 Sep 2017 20:31:29 GMT

Hi everyone,

I have a small problem but it seems that no one in the web have a solution for it, not specifically anyway.

I'm trying to change column Data Type from Numeric to Character during JSL run,

Just to be clear - I'm not trying to change Modeling Type - there are a lot of good examples for that in the web.

I'm trying to change the Data Type - (it seems no one manage to do yet).

thanks!

Re: How to change column data type from Numeric to Character?

pmroz — Thu, 31 Aug 2017 09:36:26 GMT

Go the Scripting Index, select Objects, and then scroll down to Data Table > Column Scripting. You'll find the method "Data Type" with the following example:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Wait( 2 );
dt:Age << Data Type( Character );
dt:Height << Data Type( Numeric, 2 );

Re: How to change column data type from Numeric to Character?

ariel — Thu, 31 Aug 2017 09:37:29 GMT

Hi, thanks but its not working,

I want to change an exiting column -

according to few guide the commend suppose to look like this:

column("VALUE") << Data type( Numeric ) << Set Data Type ( Character)

but still, non is working....

Re: How to change column data type from Numeric to Character?

pmroz — Thu, 31 Aug 2017 09:35:44 GMT

Remove "Data type ( Numeric)", and remove the word SET. I would also include a variable that points to your dataset.

column("VALUE") << Data Type ( Character);

or better yet:

column(dt, "VALUE") << Data Type ( Character);

where dt points to your data table.

My original example shortened a bit:

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
column(dt, "Height") << Data Type( Character );

Re: How to change column data type from Numeric to Character?

ariel — Sun, 07 Jun 2015 15:14:13 GMT

Thanks!, It's working!!

Re: How to change column data type from Numeric to Character?

Jeff_Perkinson — Fri, 09 Dec 2016 15:26:16 GMT

This OP asked about changing data type using JSL. In case you're looking to do this interactively you can select the column and then choose Cols -> Column Info...

Then in the Column Info dialog box change the Data Type.