Being a Mac user is always a disadvantage when it comes to JMP. Finally we now have xlsx import future but it seems to be worse than JMP 11. Mainly I import xls/xlsx files and then join them with other jmp data tables. Hence JMP 12 can not read the column formats (importing all the columns as character) I have to write scripts for each column data type. Better solution is still using JMP 11 for importing. Am i doing something wrong? If yes please let me know if no please developers, do something for exact data type reading capabilities of JMP 12.
JMP 11 xls import:
JMP 12 xlsx import:
If you have character and numeric data mixed in a column, or a lot of missing data, JMP 12 will be more strict about making the column character. The reason is that we received reports of lost character data when the column was mainly numeric or missing. Customers were unhappy that any data was lost.
Clean the data in Excel before import. For example remove missing value characters or comments in otherwise numeric columns. A classic, at least in some of my data sources, is occasional values typed with wrong decimal delimiter (e.g. 18.95 instead of 18,95). And don't forget the last row which may be different by default.