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?
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:
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!
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.
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.
Another 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.