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
- :
- col<<get values for non-excluded rows?

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

Nov 5, 2011 2:53 PM
(3830 views)

Anyone know of any 'simple' syntax to do this? col<<get values gets all of the column's row values (excluded, included, etc). Would be cool if their was some obscure JSL column message to get a column's rows which are not excluded. Let me know if you know... thx, dj

1 ACCEPTED SOLUTION

Accepted Solutions

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

Not pretty but it returns a matrix of the values of non-excluded rows.

col**[**dt << select where**(** Excluded**(**Row State**()****)** != **1** **)** << get selected rows**]**

2 REPLIES

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

Not pretty but it returns a matrix of the values of non-excluded rows.

col**[**dt << select where**(** Excluded**(**Row State**()****)** != **1** **)** << get selected rows**]**

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

MS, thanks a bunch! That's exactly what I was looking for and works perfectly for my needs . dj