topic Re: how to use JSL to change the column data type &format in Discussions

how to use JSL to change the column data type &format

fredwcf — Fri, 09 Jun 2023 17:07:04 GMT

I want to the column data type (charactor ---numeric) and format (best----engineering si) using JSL.I tried some scripts such as below ,but no works. Please help and any sultion will be appreciated .

dt <<Column( "Freq(Hz)"<< data type( numeric ) << Format( "Engineering SI" )
);

Re: how to use JSL to change the column data type &format

danschikore — Tue, 09 Aug 2022 11:34:14 GMT

If you are using JMP 16, try making the change interactively and then looking in the enhanced log (View > Log on Windows). Many interactive actions will give sample scripts for the operations that you perform. I tried this with the Blenders.jsl sample data and it gave this:

// Change column info: Time Cycles Data Table( "Blenders" ):Time Cycles << Data Type( Numeric, Format( "Engineering SI", 9 ) ) << Set Field Width( 12 );

If you have a dt table variable, you can use that in place of Data Table("Blenders").

Re: how to use JSL to change the column data type &format

fredwcf — Tue, 09 Aug 2022 12:13:20 GMT

I am using JMP 16, thank you for telling me the Log window function .it's very helpful .

topic Re: how to use JSL to change the column data type &amp;format in Discussions

how to use JSL to change the column data type &format

Re: how to use JSL to change the column data type &format

Re: how to use JSL to change the column data type &format

topic Re: how to use JSL to change the column data type &format in Discussions