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
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)]