topic Re: How to Create a Subset Table of the Final Row of Data per Group in Discussions

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

user8421 — Sat, 10 Jun 2023 23:28:32 GMT

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!

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

ms — Sat, 10 Apr 2021 23:34:20 GMT

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()) )
);