Create a series if new columns

Dorami — Thu, 24 Aug 2023 06:32:19 GMT

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?

Re: Create a series if new columns

jthi — Thu, 24 Aug 2023 09:17:52 GMT

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:

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

Split final data

topic Create a series if new columns in Discussions

Create a series if new columns

Re: Create a series if new columns