topic Group columns containing column properties in Discussions

Group columns containing column properties

Jackie_ — Tue, 17 Oct 2023 13:30:29 GMT

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

Re: Group columns containing column properties

txnelson — Tue, 17 Oct 2023 14:32:33 GMT

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

Re: Group columns containing column properties

Ressel — Tue, 17 Oct 2023 14:48:00 GMT

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