data management - how to split table - or make Subset - or add formula to reduce data-table

[#1]

Dear.

I would like to ask a "simple" question how to reduce my table from "how_to_go_from_here" to "to_this_table"?

When I access my data by rest-api there is a full table of data correlated by time. 

Now I want to reduce the first table to the lot-number only and plot contol-charts. As the 1st process is needed to be done a few times,

my final lot as several entries - and plotting histograms or control-charts with specs is not useful. 

Maybe someone can tell my how to manage my script running on the first table with an entry "delete rows when double or fourfold entries of lot" appear...

I am mostly interested in a script entry.

Hi Martin - maybe you know?

@martindemel 

[#2 · Accepted solution]

I think Summary could be enough in this case. You can find it from Tables menu.

and take script from summary:

Edit:

You could also select columns of interest:

Go to Rows -> Row Selection -> Select Duplicate Rows to get all rows which are duplicated based on those selected columns.

Then invert row selection to get the rows you want

and make a subset of those rows (subset only the columns you need if you don't need them all)

This can be fairly easily scripted also with the help of Scripting Index or if you have JMP16 with the enhanced log.

[#3]

Tabulate can work too, then make into data table.

(Data Table( "how_to_go_from_here" ) << Tabulate(
	Show Control Panel( 0 ),
	Add Table(
		Column Table(
			Analysis Columns( :Measurement_Process_2 ),
			Statistics( Mean )
		),
		Column Table( Analysis Columns( :Value_Process_2 ), Statistics( Mean ) ),
		Row Table( Grouping Columns( :Indicator ) )
	)
)) << Make Into Data Table

56 rows have been excluded.