- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
Depending on the data, it can work quite well. Usually XML data is not appropriate for CSV import.
Craige
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Got extra columns after open CSV file in JMP
It might be necessary to rename with .xml extension for xml import.
Craige