cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Have your say in shaping JMP's future by participating in the new JMP Wish List Prioritization Survey
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