shift row 1 up as title<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />I have a CSV file and import into JMP. Upon import into the JMP, the title is in Row 1 instead in the title section.
can i know what is the command to shift the row 1 data to become the title?
Re: shift row 1 up as titleIf you already have the data in jmp. Go to "Cols" < "Column Names" < "Move up". If you already have column names and wanted to add the row 1 meta data, select "Move up and append".
Re: shift row 1 up as titleHi Wong,
Definitely. Once you have downloaded the add-in, go to JMP, File > Open, then select the add-in (but don't open it yet) and check the box that says "Edit After Opening." This will open the add-in editor rather than installing the add-in. You can look through the different scripts for each menu item and extract what is useful.
Julian
Re: shift row 1 up as titleHi Julian,
Is there any way that i can see the code? I am writing some Jmp script to import files. I was thinking there is some code that i can execute so that i can shift the row 1 become the title of each column.
rgds,
Wong
Re: shift row 1 up as titleAnother approach is to choose "Data with Preview" when you open the CSV file. In the preview you have a chance to tell it about column headers in the raw data.
Re: shift row 1 up as titleHi WongPL,
Although the method Jeff pointed you to is a quick way to handle your problem, you might also be interested in the "Column Name Utility" add-in:
Column Name Utility
This add-in will let you shift rows up into the column names. If you run into this problem often (like when importing excel data where the file has several blank rows at the top) then this add-in will save you quite a bit of time.
I hope this helps!
Julian
Re: shift row 1 up as titleYou can copy and paste them.
Check out this blog post to see the technique.
Column Names Got You Down? Try This. - JMP Blog
-Jeff
