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
PhamBao
Level II

Got extra columns after open CSV file in JMP

Hi all,

Problem statement:
JMP table displays extra columns compared with the number of column of input file.

Detail:

I have some input files (.csv) which has only one column. However, when I load these files into JMP, JMP table displays 2 more columns. Lets take a look to image below

 

PhamBao_0-1667138442723.png

PhamBao_1-1667138555231.png

 

I believe that all csv files that I got are originally .XML files. 
Is there any possibility that I can load .csv files to JMP without changing anything

Sincerely

3 REPLIES 3
txnelson
Super User

Re: Got extra columns after open CSV file in JMP

I suggest that you specify to use the Preview

txnelson_0-1667154845663.png

when you read in your .csv file, and for the one column files, remove all of the End of Field characters

txnelson_1-1667154962928.png

That will force the input to have only one column

 

Jim
Craige_Hales
Super User

Re: Got extra columns after open CSV file in JMP

There is also an XML import wizard that might do a better job.
Depending on the data, it can work quite well. Usually XML data is not appropriate for CSV import.
Craige
Craige_Hales
Super User

Re: Got extra columns after open CSV file in JMP

It might be necessary to rename with .xml extension for xml import.

Craige