Column Name Utilities IIThis is a revision of a tool for working with column names written by @XanGregg
From the original post (link
- Move Up the first row of data to be the column names.
- Move Up and Append the first row of data to be appended to the column names.
- Move Down the column names into the first row of data.
- Recode Names to change all the column names in one dialog. Note that for JMP 14, you need to use the JMP14 version of the add-in and select the "In Place" option in the Recode platform.
Notes:
2018-08-30: Added a second version of the Addin that accounts for some changes to the Recode Platform in JMP 14.
UtilitiesRe: Column Name Utilities IIgreat help. I was converting the file to excel and then importing using excel import wizard.! This is a big time saver.
Re: Column Name Utilities IIHi! Thanks for the praises! Xan deserves most of them - the addin was his concept. I just tweaked a couple of compatibility issues that crept in.
On your question, there’s a trick I use to do what you’re describing using the current addin. If you look, when the recode window is open, you’ll see the addin creates a table of the column names. If you’ve got a table with names, or can generate your new column names using formulas, you can just paste the new values into the addin generated table. Then you simply cancel the recode operation. Whatever is in the data table will then become the new column names.
Also, I’d recommend having a hard look at the capabilities of recode in JMP 14. There’s not a lot the new implementation can’t do. The developer really out did themselves with the changes in 14.
Happy Recoding!
Best,
M
Re: Column Name Utilities IIHi Mike,
I really like your AddIn especially the "recode" option for managing column names. I would like to ask you if you or one of your colleague know about an AddIn that would rename a series of columns based on the names of another series of columns?
Example:
Starting table
| Name | Data1 | Data2 | Data3 |
| AAA | 3 | 4 | 5 |
| BBB | 5 | 6 | 4 |
Intermediate table where 3 columns were added, formulas were entered via Standardize Attributes:
| Name | Data1 | Data2 | Data3 | Column1 | Column2 | Column3 |
| AAA | 3 | 4 | 5 | Log10 (3) | Log10 (4) | Log10 (5) |
| BBB | 5 | 6 | 4 | Log10 (5) | Log10 (6) | Log10 (4) |
Final table (processed by requested AddIn:
| Name | Data1 | Data2 | Data3 | Log10 Data1 | Log10 Data2 | Log10 Data3 |
| AAA | 3 | 4 | 5 | Log10 (3) | Log10 (4) | Log10 (5) |
| BBB | 5 | 6 | 4 | Log10 (5) | Log10 (6) | Log10 (4) |
Re: Column Name Utilities II@saitcopuroglu, you'd have to go into the add-in and pull out the JSL.
M
Re: Column Name Utilities IIHow could I get/copy the JSL of recoding column names please? There is a "script" menu but after clicking it I can not see the script anywhere. Thanks in advance
Re: Column Name Utilities II@XanGregg deserves the credit. I just went in and fixed a couple of things that needed to be changed in the original JSL. Thanks all the same!
Best,
M
Re: Column Name Utilities IIThanks Mike, I used this today on some Internet data I imported. Perfect!
-ryan
