Using Column Properties in Column Functions?

MoarData

Is there a way to create a new function column within a table that uses the properties of another column along with that column's data?

 

For instance, making a flag column for items outside of assigned LSL and USL?

 

I know I can do it by using JSL and iteratively evaluating cell values and Get Property ... etc, but that seems unnecessarily complex for such a simple comparison and logic operation. In particular, the nested Spec-->LSL and Spec-->USL are not easy to work with when one or both may be missing on a particular column.

 

jthi

You could use a formula with something like this:

</CODE><BR /><CODE class=" language-jsl">If(Row() == 1,
	specs = :NPN1 << Get Property("Spec Limits");
	lsl = Try(specs["LSL"], .);
	usl = Try(specs["USL"], .);
	val = .;
);
val = IfMZ(:NPN1 < lsl | :NPN1 > usl, 1, 0);
val;

but if you have many columns to check, I think this is easier to do on tall/stacked data in which you can have columns such as parameter, value, lsl and usl. Then with those you can easily create a formula for flagging.

 

Some platforms also allow you to select and color out of spec values, but these might work only on one column at a time.