nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to write a script to be able to plot any parameters based on the raw data ?

XiangCD_MP_User

Hi All,

I was thinking hard about the ways to do automation using JMP recently. Are there any scripts which could do this:-

(1) I have the raw data saved in a JMP table.

(2) I have a script that will automatically plot the graphs (example, var chart) by grabbing any Y variables from the Colume (in the raw data) and plot by a fix X parameter (defined in the script). This will save some time to name all the Y variables in the script, especially when I have ~50 parameters to be added into the script.

Thank you,

Ann

Accepted answers

txnelson

By default, the Save Presentation() function will write on top of any previous pptx created, unless you specify the "Append" option. See the documentation in the Scripting Index.

All comments

txnelson

Ann,

Once the X and Y columns are identified, this becomes a fairly easy task to setup. You specify that the X columns would be defined in the script, so that one is handled. But I am a little confused about the Y columns. Could you provide a little more detail on how one would identify a Y column in your data table?

Any continuous, numeric column?

Any column not defined in your script as an X column?

Any column starting with a specific series of letters, etc.

XiangCD_MP_User

Hi Jim,

The Y variables would have these features below:
(1) they are numeric columns
(2) the parameters' name would always begin with a serial number, then followed by alphabets. For example:

001: voltage_dif <> PinOut

002: resistance_div <> PinIn

Thank you,
Ann Ann

txnelson

Here is a simple example that should get you started.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\semiconductor capability.jmp" );

// Modify the sample data table to resemble Ann's data table

// Reduce the number of columns for the demonstration
dt << delete columns( Index( 15, N Cols( dt ) ) );

// Add a Serial Number to the parameters
For( i = 5, i <= N Cols( dt ), i++,
	Column( dt, i ) << set name(
		Substr( "000", 1, 3 - Length( Char( i - 4 ) ) ) || Char( i - 4 ) || ":" ||
		Char( Column( dt, i ) << get name )
	)
);

// Wait 5 seconds to allow for viewing of the new table before running the 
// actual analysis script
Wait( 5 );

/**************************************************************************/

// Actual Analysis Script Example

// Point to the current data table
dt = Current Data Table();

// Find the Y Columns
numericColNamesList = dt << get column names( string, numeric );

// Loop accros the list from back to front and delete all columns
// not meeting the right structure
// nnnnn:cccccc
For( i = N Items( numericColNamesList ), i >= 1, i--,
	If(
		Not(
			Is Missing( Num( Word( 1, numericColNamesList[i], ":" ) ) ) == 0 &
			Word( 2, numericColNamesList[i], ":" ) != ""
		),
		numericColNamesList = Remove( numericColNamesList, i, 1 )
	)
);

// Run the Variance Charts
// With dynamic Y columns and fixed X columns
Variability Chart( Y( Eval( numericColNamesList ) ), X( :lot_id, :SITE ) );

XiangCD_MP_User

Thank you so much, Jim. This is indeed very inspiring to me.

If I would love to export all these graphs to Excel, do I need to load in the counter, i too ?