How to Create a Subset Table of the Final Row of Data per Group

user8421

Hi!

Is there a way to automate the creation of a subset table such that this is the starting data table

Group	Data1	Data 2
A	1	A
A	2	T
A	3	C
B	8	F
B	2	R
C	1	E
C	4	G
C	1	O
C	5	E

And this is the subset table (the final row of each group)

Group	Data1	Data 2
A	3	C
B	2	R
C	5	E

Any help appreciated!  Thanks!

ms

I can see several ways to do this with JSL. Try this:

 

Names Default To Here( 1 );
dt = Current Data Table();
dt << Subset(
	Selected Columns( 0 ),
	Rows( dt << Get rows where( Col Max( Row(), :Group ) == Row()) )
);