Range Check on Derived ColumnsHi everyone,
I have copied/duplicated columns in my data table. I would like to do a range check on the copied columns, but when I do, it tells me that I can not do a range check on derived columns. The easiest work around (I think) would be to just do the range check on the original column, but I would like to know if there is a way to do this on the copied column.
Current Data Table(dt);
cn = dt << get column names();
For(i=5, i <= N Items(cn), i++,
name = Char((cn[i])) || " Pass";
dt << clear column selections;
colCopy = cn[i] << getscript;
Eval(Substitute(Name Expr(colCopy), Arg(Name Expr(colCopy),1), name )) << set selected(1);
col = Column(name);
dt:col << Suppress Eval;
);
dt:Gate Pass << Set Property("Range Check", LTLE(0,50) );
Re: Range Check on Derived ColumnsThat certainly explains it! Glad you figured it out.
Re: Range Check on Derived ColumnsThe problem was so obvious! I didn't set the data type to numeric. Ah!
Re: Range Check on Derived ColumnsIs the code you posted exactly what you're using? If not please post anything that's missing
Re: Range Check on Derived ColumnsA column populated by a formula would include the range checking in the formula itself. For example,
If( lower bound < computation < upper bound, result, . )
Re: Range Check on Derived ColumnsOh actually it's happening on columns that weren't even copied. Has anyone seen this problem before?
Re: Range Check on Derived ColumnsOh really? I am using JMP 12.Re: Range Check on Derived ColumnsNot able to reproduce your issue. I am using JMP 12/13. I am able to apply a range check to the new columns as you explained. Now, if a column is based on a formula, then no, you cannot apply Range Check. What version of JMP are you using?
