- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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!
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Data table question
Find the answer. Thank you!