BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Confa

Occasional Contributor

Joined:

Feb 19, 2019

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

 

2 REPLIES 2
ms

Super User

Joined:

Jun 23, 2011

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

Joined:

Feb 19, 2019

Re: trasform data in one table.

Dear ms

thank you very much, it works perfectly!

 

Sincerely

 

Stefano