topic How to determine a column has formula? in Discussions

How to determine a column has formula?

DivisiveEagle45 — Sat, 10 Jun 2023 23:57:59 GMT

I would like to remove all formulas from all columns with script. I wrote a forloop but whether a column has formula needs to be determined. How to do that with scripts?

Re: How to determine a column has formula?

jthi — Thu, 08 Dec 2022 19:14:49 GMT

One option is to use <<Get Formula with Is Empty()

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
col1 = dt << New Column("Ratio", Numeric, Continuous);
col1 << Formula(:height / :weight);
wait(1);

For Each({col_name}, dt << Get Column Names("String"),
	col = Column(dt, col_name);
	If(!Is Empty(col << get formula),
		Column(dt, col_name) << Delete Formula
	);
);

Scripting Index has a lot of information and you can find it directly from JMP's menu Help / Scripting Index

If you add those formulas yourself and don't really need them for formula usage, you can avoid adding them all together by using << Set Each Value()

Re: How to determine a column has formula?

DivisiveEagle45 — Wed, 30 Aug 2023 23:06:22 GMT

It worked!

Thank you so much!