topic Rename a column jsl script in Discussions

Rename a column jsl script

DKI — Mon, 13 Feb 2017 16:54:31 GMT

I am pretty new to JSL scripting. I cant seem to find a script to rename of a column header from one name to another

Appologies this is probably obvious to most here

Re: Rename a column jsl script

txnelson — Mon, 13 Feb 2017 17:09:01 GMT

Here is an example from

Help==>Scripting Index==>Data Table==>Column Scripting

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
:Age << Set Name( "Time" );

Re: Rename a column jsl script

DKI — Mon, 13 Feb 2017 17:20:12 GMT

Thanks alot Jim

Thats exactly what I needed. I was using a variation on that script that I had been messing around with for ages and could not make it work.

Thanks also for showing where you found it.

Re: Rename a column jsl script

Mark_Bailey — Mon, 13 Feb 2017 17:51:21 GMT

In the future, you might find the on-line help useful. In this case:

Select Help > Scripting Index.
Change the drop-down menu from initial All Categories to Objects.
Select Column Scripting under Data Table in the first list.
Select Set Name in the second list.

You will find the correct syntax with arguments and options. You can run an example and observe the result. You can click Topic Help to go to the more complete coverage in the main help system.

You can also search in Objects with column name for example to find all related functions or messages.

Re: Rename a column jsl script

GreenisBTFL — Wed, 18 Jun 2025 19:54:39 GMT

The script you suggest works well when a user is working with only one table. But I've been trying to change the name of a specific column within one of several tables open, and cannot find guidance within the Scripting Index. What would the JSL syntax be for this scenario?

Example

I am working with two tables (Cdt1 and Cdt2) and Cdt1 has a column with name "value" that I want to change to "Fault code"

I've tried to select the "value" column first before changing the name, but that didn't help.

Cdt1 << Select Columns("value");
Column("value") << Set Name( "Fault code" );

My other attempt was worse...

Cdt1 << Columns("value") << Set Name ("Fault code");

Either way, I haven't been successful after a while of trying and looking for guidance. Any help would be appreciated.

Re: Rename a column jsl script

mmarchandFSLR — Wed, 18 Jun 2025 20:16:08 GMT

From the scripting index:

So your code should be:

Cdt1:value << Set Name( "Fault code" );

Column( Cdt1, "value" ) << Set Name( "Fault code" );