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
- :
- JSL Performance and Computed Columns

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

Apr 13, 2011 1:02 PM
(610 views)

I have a dataset containing 180,000 rows. There are 7 computed columns. I'm programmatically adding about 160 new columns which are not computed. I notice that as I'm doing that I get messages in the lower left corner like "evaluating V0 Quarter", "evaluating Year-Week", ... "evaluations done". These are the names of my computed columns. I don't need the computed columns to add the new columns.

Is there a way to temporarily "suspend" formula evaluation? It seems to be adding quite a bit of time to the process.

Thanks,

Peter

2 REPLIES

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

Apr 13, 2011 1:35 PM
(558 views)

dt = current data table();

dt << suppress formula eval(1);

add a bunch of columns;

dt << suppress formula eval(0);

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

Apr 22, 2011 8:49 AM
(558 views)

Thanks a lot,

Peter