Group columns containing column properties

Question

Hello,

Is there a way to use contain to search the column properties and group them if only the column contains spec limits properties?

Trying to group the columns that contain the column property "Spec Limits". Any advice?

Thanks,

Jackie

Test data.jmp

txnelson · Accepted Answer

You just need to go through the numeric columns and put into a list, the ones with Spec Limits.  Then use the Group Columns message to create the group

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

theNames = dt << get column names( numeric, string );

specLimitsList = {};
For Each( {colName}, theNames,
	If( Is Empty( Column( colName ) << get property( "Spec Limits" ) ) == 0,
		Insert Into( specLimitsList, colName )
	)
);
dt << group columns( "HaveSpecLimits", specLimitsList );

Ressel · Accepted Answer

This should work on your example table:

Names Default To Here( 1 );dt = Current Data Table();colList = dt << Get Column Names();For( i = 1, i <= N Items( colList ), i++,	If( Contains( Char( (Column( i ) << Get Column Properties( string )) ), "Spec" ),		Column( i ) << set selected	));dt << group columns( "name of your group" );