topic Re: Data table question in Discussions

Data table question

Sun, 06 Jun 2010 20:57:14 GMT

Hello,

I just started learning JMP and have a question about manipulating data table.

There is one column in my data table, whose name is given by a string variable X, say X="height". I want to make a duplicated column called X1. So I use

new column("X1", numeric, formula(name("X")));

But instead of filling X1 with numbers in Column X=height, it fills it with char "height". How can I fix this? I don't want to use

new column("X1", numeric, formula(height));

since I'd like the script to be able to run on different data tables and X would be different strings from time to time.

Thanks!

Re: Data table question

mpb — Sun, 06 Jun 2010 22:49:11 GMT

If you search the JMP forum for "column formula variable" (without the quotes) you will see a list of threads which discuss how to use variables containing column names in formulas.

Re: Data table question

Mon, 07 Jun 2010 02:35:54 GMT

Find the answer. Thank you!