Choose Language Hide Translation Bar
Confa
Occasional Contributor

trasform data in one table.

Goodevening,

I have a huge table, 1992 columns x 35.655 rows and I would like to trasfotrm all of them in l 2^x  and create a new table (ok I can skip this, I can save it with another name).
 
I tried with the formula editor, by selecting a column and type in the desired formula but it doesn't work...
If I select data from anothe column in the same formula it works, but obviously it is not good.

I would like to replace all values, not to create new columns, I have enough of them :)
Thank you

 

Stefano

 

0 Kudos
2 REPLIES 2
ms
Super User ms
Super User

Re: trasform data in one table.

If you have a later version of JMP that supports the data table matrix syntax, this approach would be efficient for replacing all data with their transformed values. The code assumes all columns from column 3 to end of table are numeric (as in the screenshot).

 

dt = Current Data Table();
f = 3; //first numeric column
dt[1 :: N Row(dt), f :: N Col(dt)] = 2 ^ dt[1 :: N Row(dt), f :: N Col(dt)]
;

 

Confa
Occasional Contributor

Re: trasform data in one table.

Dear ms

thank you very much, it works perfectly!

 

Sincerely

 

Stefano

0 Kudos