topic Re: Got extra columns after open CSV file in JMP in Discussions

Got extra columns after open CSV file in JMP

PhamBao — Sat, 10 Jun 2023 23:56:14 GMT

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

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

Re: Got extra columns after open CSV file in JMP

txnelson — Sun, 30 Oct 2022 18:36:51 GMT

I suggest that you specify to use the Preview

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

That will force the input to have only one column

Re: Got extra columns after open CSV file in JMP

Craige_Hales — Sun, 30 Oct 2022 21:50:37 GMT

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.

Re: Got extra columns after open CSV file in JMP

Craige_Hales — Sun, 30 Oct 2022 23:52:16 GMT

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