cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar

Jmp not recognizing the column headers from excel

I am trying to open an excel file from JMP to start analysis. This excel file has the column headers on row 1, but JMP is not able to detect the column names even after selecting the check mark on the import option and additionally, JMP only shows columns from 6 and doesn't read all the columns. First screenshot is jmp export page not detecting the column names. Second screenshot is the excel file that has column names. Can I know how to fix this import issue?  Thank you

ClassMandrill86_0-1679340584170.png

ClassMandrill86_1-1679340709568.png

 

 

10 REPLIES 10
StarfruitBob
Level VI

Re: Jmp not recognizing the column headers from excel

If I understand your thread correctly, and you're using JMP 17, it might be related to this bug that was found.

https://community.jmp.com/t5/Discussions/Problem-Importing-Raw-Excel-Data-in-JMP-17/m-p/616405#M8160... 

Learning every day!