cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar

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 2
mpb
mpb
Level VII

Re: Data table question

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

Find the answer. Thank you!