Hello All,
I created this script to open a text file, filter the data, and then generate a run chart.
Is there away I can also have the script automatically save the run chart as a .gif/.jpeg file in a chosen directory?
The exact script can be seen below. Thank you for the help!
Open(
"R:\Operations\Engineering\FTP DATA\FT_LPC_Results.txt",
Date = Numeric,
Time = Numeric,
Lot # = Character,
Part # = Character,
Brush # = Character,
Station # = Numeric,
LPC = Numeric,
Column 8 = Numeric,
Column 9 = Numeric,
Column 10 = Numeric,
Column 11 = Numeric,
Column 12 = Numeric,
Column 13 = Numeric,
Column 14 = Numeric,
Column 15 = Numeric,
Column 16 = Numeric,
Column 17 = Character
),
End Of Line( CRLF, CR, LF ),
End Of Field( Tab, Comma ),
Strip Quotes( 1 ),
Use Apostrophe as Quotation Mark( 0 ),
Scan Whole File( 1 ),
Labels( 1 ),
Column Names Start( 1 ),
Data Starts( 2 ),
Lines To Read( All ),
Year Rule( "10-90" )
);
Current Data Table() << Data Filter(
columns( :Part # ),
Where( :Part # == "H2FEN-70-31NM-0317" ),
Display( :Part #, Size( 204, 259 ), List Display )
);
Data Table( "FT_LPC_Results" ) << Subset( Copy formula( 0 ) );
Sample Label( :Lot # ),
Sample Size( 1 ),
KSigma( 3 ),
Chart Col( :Name( "LPC >0.1" ), Run Chart( Show Center Line( 0 ) ) ),
{},
"Run Chart of LPC >0.1",
OutlineBox,
Set Title( "H2FEN-70-31NN-0317 - LPC" )
),
{"Run Chart of LPC >0.1"},
"2",
ScaleBox,
{Min( 39.2945275076211 ), Max( 2195.92103353172 ), Inc( 250 ),
Add Ref Line( 2000, Solid, {255, 0, 0}, "USL 2000" )}
),
{"Run Chart of LPC >0.1"},
"1",
ScaleBox,
{Min( 15230.3237 ), Max( 19677.7118706835 ), Inc( 8 ),
Rotated Labels( 1 )}
),
{"Run Chart of LPC >0.1"},
"Run Chart",
FrameBox,
Frame Size( 897, 415 )
),
{"Run Chart of LPC >0.1"},
"Run Chart",
FrameBox( 2 ),
Frame Size( 69, 415 )
);