Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Level III

Change column names at once



I have a data table with several continuous columns, each column with a different name. I wish to: 1) duplicate continuous columns all at once; 2) rename these new columns with their original names (i.e., lady beetle) plus add "/100" to their names (i.e., column name would be: lady beetle/100) all at once; then 3) I want to multiply these new columns by 4 all at once (only the continuous columns).

Could anyone can help me with a script that could do these three things, please?


I'm using JMP 16.1 (MacBook).


Thank you!


Here is an example of how my data looks like, but I have several continuous columns:

Screen Shot 2022-10-19 at 2.00.18 PM.png






Super User

Re: Change column names at once

Here is how I would solve the problem.  The only issue with this code, is the determination of what columns to process.  Assuming that Date and Process Date are JMP Date columns, they are continuous columns and therefore have to be deleted from the processing.

Names Default To Here( 1 );

dt = Current Data Table();

cols = dt << get column names( string, continuous );
Remove From( cols, 1, 1 );
Remove From( cols, N Items( cols ), 1 );

dtTemp = dt << subset( selected rows( 0 ), columns( cols ) );

dtTemp[0, 0] = dtTemp[0, 0] * 4;

For Each( {name}, cols,
	Column( dtTemp, name ) << set name( (Column( dtTemp, name ) << get name) || "/100" )

dt << Update( With( dtTemp ) );

Close( dtTemp, nosave );
Level XI

Re: Change column names at once

without JSL?

via Custom Column transformations from @ih's add-in collection: 

here is a wish to include this add-in collection in standard JMP: 



Level XI

Re: Change column names at once

The easies way to rescale multiple columns at once: select the columns - right click - New Formula Column - Transform - Scale Offset ...




please note the meaningnful names of the new columns :)
If you want to change it to (... /100), you could do it manually or use @ih' s Rename Columns AddIn: