cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Nested Measurement System Analysis (MSA) Quick Recoder

When working with the Measurement System Analysis platform, nested designs will create rows containing information on the 'nest' that each column is contained within (see below). 

Ben_BarrIngh_0-1723557065413.png

 

To make the data tables clearer/easier to interpret, the rows can be recoded to remove the nesting references. The MSA recoder allows users to select multiple columns and removes all nested sections. Simply click the add-in, select the columns you want to remove the nesting references from and the columns will be recoded.

Ben_BarrIngh_1-1723557147868.png

Ben_BarrIngh_2-1723557162327.png

 

 

Note: cleaning the rows does not effect the variability gauge analysis as the nesting order is retained, but use on the graph builder/Fit Y by X will treat the groups as crossed rather than nested, be mindful of this when performing analysis.

 

 

 

Comments
Names Default To Here( 1 );

dt = Current Data Table();

// Get a list of column names and allow the user to select multiple columns
MSACols = dt << Get Column Names( Character );
New Window( "Select the columns to clean:",
	<<Modal,
	clb = Col List Box( <<Set Items( MSACols ) )
);
MSACols = clb << Get Selected;

//Apply transformations to each column

dt << Begin Data Update;

// Loop through each selected column and remove anything after [ created by MSA 
For( i = 1, i <= N Items( MSACols ), i++,
	// Get the current column name
	colName = MSACols[i];
	// Recode each column
	For Each Row(
		Column( dt, colName )[] = Word(
			1,
			Column( dt, colName )[],
			"[",
			Unmatched( Column( dt, colName )[] )
		)
	);
);

dt << End Data Update;

Recommended Articles