Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- trasform data in one table.

Topic Options

- Start Article
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

trasform data in one table.

Mar 15, 2019 11:26 AM
(195 views)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: trasform data in one table.

Dear ms

thank you very much, it works perfectly!

Sincerely

Stefano