cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Dorami
Level I

Create a series if new columns

I have a table with column F1 to F10 which contains temperature in Fahrenheit, I would like to create another sets column C1 to C10 in Celsius within the same table. How can I do that?

1 REPLY 1
jthi
Super User

Re: Create a series if new columns

Quite many options. There are addins (to my knowledge) which could do this, you could write a script or you could do it interactively in JMP by stacking your data, renaming columns, adding new column to calculate C and then splitting the data back.

Start data:

jthi_0-1692868547917.png

Stacked data with some cleanup (Recode columns to remove F from Label and new C column to perform calculations)

jthi_1-1692868586233.png

Split final data

jthi_2-1692868621580.png

 

-Jarmo