This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
hgarbig
hgarbig
Level I

Import excel in JMP18

This widget could not be displayed.
Created: Jul 24, 2024 01:58 PM  |  Last Modified: Jul 24, 2024 10:58 AM (99 views)

Previously using JMP17, any import format of a column in excel would carry over the same format into JMP, but JMP18 is changing from numeric to character if there are any blank cells in that column.  Is there a setting in preferences I need to change?

0 Kudos
1 REPLY 1
jthi
Super User jthi
Super User

Re: Import excel in JMP18

This widget could not be displayed.
Created: Jul 24, 2024 02:09 PM  |  Last Modified: Jul 24, 2024 11:14 AM (91 views)  |  Posted in reply to message from hgarbig 07-24-2024

I don't think there are such settings. You might be able to change the format in the excel wizard

jthi_0-1721844432693.png

or better option in my opinion, change the data and modeling type AFTER you have imported the data into JMP table.

 

Edit: You can get information about the excel import from https://www.jmp.com/support/help/en/18.0/#page/jmp/preview-and-import-microsoft-excel-data.shtml# and there were changes in JMP18 https://community.jmp.com/t5/JMP-Knowledge-Base/Changes-to-the-import-of-Microsoft-Excel-files-in-JM... 

-Jarmo
0 Kudos