nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

562239_en-US

liliconcom

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

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

Data Table

Scripting

Re: Got extra columns after open CSV file in JMP

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

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.