topic Re: Data Preview in Column Formula correct, but values not appearing in Column in Discussions

Data Preview in Column Formula correct, but values not appearing in Column

cxu04 — Sat, 10 Jun 2023 23:35:14 GMT

Hello,

I've created a set of columns with a for loop with the below script

For(i=1, i<= N Items(abs_cols), i++,
Eval(
	Substitute(
		Expr(
			New Column(__name2__,
				Formula(
					If(__zscore__ < 2, __abs__)
				)
			)
		),
	Expr(__name2__), "Outliers Removed " || char(abs_cols[i]),
	Expr(__zscore__), Column("Z-score " || char(abs_cols[i])),
	Expr(__abs__), Column(char(abs_cols[i]))
	)
)
);

When I run this script, the columns are created with the correct formulas, but no values are filled in any of the new columns. More puzzling is that the Data Preview shows exactly the values as I want them to be filled.

I'm not sure what's going on, please help?

Re: Data Preview in Column Formula correct, but values not appearing in Column

ih — Tue, 10 Aug 2021 22:06:45 GMT

It has to do the function Column() not playing well with column formulas, at last in my experience. Instead you might try `As Column`, like this:

Names default to here(1);

dt = Open("$Sample_data/iris.jmp");
New Column("Z-scoreSepal length", Numeric, "Continuous", Format("Best", 12), Formula(Random Normal()));
New Column("Z-scoreSepal width", Numeric, "Continuous", Format("Best", 12), Formula(Random Normal()));

abs_cols = {:Sepal length, :Sepal width};

For(i=1, i<= N Items(abs_cols), i++,
	Eval(
		Substitute(
			Expr(
				New Column(__name2__,
					Formula(
						If(As Column(__zscore__) < 2, As Column(__abs__))
					)
				)
			),
			Expr(__name2__), char(abs_cols[i]),
			Expr(__zscore__), "Z-score " || char(abs_cols[i]),
			Expr(__abs__), char(abs_cols[i])
		)
	)
);

Re: Data Preview in Column Formula correct, but values not appearing in Column

cxu04 — Tue, 10 Aug 2021 23:15:48 GMT

you're right, that worked! thanks so much!