BookmarkSubscribeRSS Feed
djhanson
Community Trekker

col<<get values for non-excluded rows?

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

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User ms
Super User

col<<get values for non-excluded rows?

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 2
ms
Super User ms
Super User

col<<get values for non-excluded rows?

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]

djhanson
Community Trekker

col<<get values for non-excluded rows?

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

0 Kudos