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
- :
- Columns automatically updating?

Topic Options

- 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

Jun 8, 2016 11:15 AM
(1719 views)

Hi All,

My columns are automatically updating after excluding rows.

I want to rank a column (let's call it Column A) in a new column (Column B). Afterwards, I exclude rows based on some condition. Next, in a new column (Column C), I want to rank Column A with the excluded rows. It does this, but then Column B is updated with the excluded rows and is exactly the same as Column C. Is there anyway around this? Do the columns have to automatically update?

1 ACCEPTED SOLUTION

Accepted Solutions

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

Jun 8, 2016 1:30 PM
(3264 views)

Solution

Natalie,

I think what you need to do, is to apply the formula in column B and then then remove the formula, leaving the values, but not the formula. You can do this interactively or in a script, if that is how you are approaching the problem.

:column B << delete formula;

Another approach would be to suppress the evaluation of the formula

:column B << Suppress Eval;

Jim

2 REPLIES

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

Jun 8, 2016 1:30 PM
(3265 views)

Natalie,

I think what you need to do, is to apply the formula in column B and then then remove the formula, leaving the values, but not the formula. You can do this interactively or in a script, if that is how you are approaching the problem.

:column B << delete formula;

Another approach would be to suppress the evaluation of the formula

:column B << Suppress Eval;

Jim

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

Jun 8, 2016 2:14 PM
(1632 views)

Hi Jim,

Thank you so much! I assumed that would remove everything, but now that I know I can keep the values, the will help me a lot.