- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
JSL script for summary table with for loop
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
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: JSL script for summary table with for loop
Created:
Sep 9, 2020 09:12 AM
| Last Modified: Sep 9, 2020 6:13 AM
(1975 views)
| Posted in reply to message from chungman89 09-09-2020
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" )
);
Jim
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: JSL script for summary table with for loop
Created:
Sep 9, 2020 09:12 AM
| Last Modified: Sep 9, 2020 6:13 AM
(1976 views)
| Posted in reply to message from chungman89 09-09-2020
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" )
);
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content