topic JSL script for summary table with for loop in Discussions

JSL script for summary table with for loop

chungman89 — Sat, 10 Jun 2023 23:18:52 GMT

Hello, I am creating a script for summary table with a for loop as there are multiple parameters from the PCM test. The script I have created was based on the JSL script generator and replace the mean () with colNames [i]. It did work but poped out 100s of data table for each parameter.

Previously, I had a similar issue with the graphs and a gentleman replied with the solution nw = new window(). I tried this and it did not work so I tried dt_summary = new table() and did not work either. Can I have your advice on this problem?

dt = Current Data Table();

// Get the all of the numeric, continuous column names
colNames = dt << get column names( string, continuous );



nw = newtable (For( i = 1, i <= N Items( colNames ), i++, // N Items( colNames ), i++,
	
	// Mean value based on Wafer number and LotID
	
	dt<< Summary(
	Group( :WF_NUM),
	Mean( colNames[i] ),
	Freq( "None" ),
	Weight( "None" )	
)));

Thank you for your help.

Dominic

Re: JSL script for summary table with for loop

txnelson — Wed, 09 Sep 2020 13:13:27 GMT

There is not a need for a For() loop. All of the means can simply be done at the same time

Names Default To Here( 1 );
dt = Current Data Table();

// Get the all of the numeric, continuous column names
colNames = dt << get column names( string, continuous );
	
	// Mean value based on Wafer number and LotID
	
sumDT = dt << Summary(
	Group( :WF_NUM ),
	Mean( colNames ),
	Freq( "None" ),
	Weight( "None" )
);

Re: JSL script for summary table with for loop

chungman89 — Wed, 09 Sep 2020 13:15:50 GMT

Hello @txnelson

Thank you for prompt response and simple solution.

Regards

Dominic