Subscribe Bookmark RSS Feed

Data table question

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!
2 REPLIES
mpb

Super User

Joined:

Jun 23, 2011

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.
Find the answer. Thank you!