Subscribe Bookmark RSS Feed

shift row 1 up as title

wongpl

Community Trekker

Joined:

Jun 23, 2011

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?

5 REPLIES
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

You can copy and paste them.

Check out this blog post to see the technique.

Column Names Got You Down? Try This. - JMP Blog

-Jeff

-Jeff
julian

Staff

Joined:

Jun 25, 2014

Hi 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

wongpl

Community Trekker

Joined:

Jun 23, 2011

Hi 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

julian

Staff

Joined:

Jun 25, 2014

Hi 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

XanGregg

Staff

Joined:

Jun 23, 2011

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.