cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

Got extra columns after open CSV file in JMP

PhamBao
Level II

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