Group columns containing column properties

[#1]

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

[#2 · Accepted solution]

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 );

[#3 · Accepted solution]

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" );