topic Re: Changing column values based on the column spec limit in Discussions

Changing column values based on the column spec limit

Yngeinstn — Sat, 10 Jun 2023 23:28:43 GMT

We have a phase test that sometimes likes to flop the value by 360 degrees. I would like a script that can look through the table column data, take an average and then compare it to the LSL / USL. If the sign of the average is opposite the spec limit add 360 to that value.

I can't do a blanket If( :test < 0, t1 = :column + 360; t1; ) due to the way the tester handles the data.

I have attached a sample table and the last two columns are where my issue is.

Thanks in advance

Re: Changing column values based on the column spec limit

txnelson — Thu, 15 Apr 2021 17:23:41 GMT

See if this little script gives you what you want

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

colList = dt << get column names( continuous, string );

For( i = 1, i <= N Items( colList ), i++,
	specs = Column( dt, colList[i] ) << get property( "spec limits" );
	If( Is Missing( specs["LSL"] ) == 0 & Is Missing( specs["USL"] ) == 0,
		If( !(specs["LSL"] <= Col Mean( Column( dt, colList[i] ) ) <= specs["USL"]),
			For Each Row( As Column( dt, colList[i] ) = -1 * As Column( dt, colList[i] ) )
		)
	);
);

Re: Changing column values based on the column spec limit

Yngeinstn — Thu, 22 Apr 2021 13:40:53 GMT

Thank you Mr. Nelson.

I had to modify the script a little bit. I changed the multiplication to addition and changed the Mean to Median. I didn't account for catastrophic failures when i made the original post. Columns 40 and 41 had col mean values that were not between the LSL and USL.

Names Default To Here( 1 ); dt = Current Data Table(); colList = dt << get column names( continuous, string ); For( i = 1, i <= N Items( colList ), i++, specs = Column( dt, colList[i] ) << get property( "spec limits" ); If( Is Missing( specs["LSL"] ) == 0 & Is Missing( specs["USL"] ) == 0, If( !(specs["LSL"] <= Col Median( Column( dt, colList[i] ) ) <= specs["USL"]), For Each Row( As Column( dt, colList[i] ) = 360 + As Column( dt, colList[i] ) ) ) ); );