Lack of continuity opening CSV Files

matt7109

Hi,

It seems like most of the time, when  I open a CSV file as a JMP table, the first row of the CSV file become column names. However, on some occasions, when I open the same CSV files, the first row of the CSV file will become the first row of the JMP table with no column names. 

Why is this and how can I ensure continuity when opening CSV files?

Craige_Hales

The preferences control how JMP interprets the CSV. The default assumes there are column names on line one of the CSV.

Text Import Preferences

If you tell JMP to guess (radio buttons at top), then you might get the behavior you describe because JMP guesses there are no column names if there are numeric values on the first row.

If you are importing the same file structure (same columns, same names) again and again, you might want to use the "source" script stored in the table to repeat the process. It will not depend on preferences.