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: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
OutputCivet4254
OutputCivet4254
Level I

JMP import csv, shows as empty

Feb 5, 2024 04:14 PM (570 views)

Hi team, 

 

The table shows as empty when i choose to import through csv file. I saw couple posts before showing there is a issue with uploading with csv, just wondered if there is a workaround for this issue? Or do I have to upload through xlsx file?  

 

Thanks

Jason

0 Kudos
1 REPLY 1
txnelson
Super User txnelson
Super User

Re: JMP import csv, shows as empty

Created: Feb 5, 2024 05:14 PM  |  Last Modified: Feb 5, 2024 2:17 PM (563 views)  |  Posted in reply to message from OutputCivet4254 02-05-2024

You should try using Preview when opening your csv file.  It will let you see what JMP is doing with the data

  1. Go to   File=>Open
  2. At the far right, lower portion of the window, click on the File Type drop down arrow and select                                              "Text Files (*.txt,*.csv,*.dat,*.tsv)
  3. Select in the "Open as"  area, "Data (Using Preview)

txnelson_1-1707171450073.png

 

After you select the file you want, and click on Open, the Preview Wizard will guide you through the .csv import process, and you will see a preview of how JMP is interpreting the data

 

Jim