cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Ekarshalev
Level II

Importing data but column type is not changing to what I want

Hello All,

So basically, my problem originates with the importation of some csv data. I have a mix of numeric and character columns that I am importing. I had first imported the data through the wizard and then used the data table to generate plots. From there I made a dashboard and used the plots and the data table as part of the dashboard script.

I noticed that a column that I am importing is getting imported as a numeric continuous although I would prefer it is imported as a character nominal format. So I went back to the dashboard building script and changed that manually. However, no matter how I run the script the column continues to get imported as a numeric continous. I have included the column in an csv if anyone wants to try.

I tried a simple script to just import the data table without a dashboard portion and this imports it correctly as the character nominal format. Not sure where the issue is.

Any help will be appreciated since I think I am doing the right thing but the final answer is not coming out as expected

2 REPLIES 2
Craige_Hales
Super User

Re: Importing data but column type is not changing to what I want

Can you post a complete example (with a dashboard) that demonstrates the problem? I made a tiny dashboard and it worked, using the character/nominal attribute.

The dashboard just reopens the tableThe dashboard just reopens the table

Craige
Ekarshalev
Level II

Re: Importing data but column type is not changing to what I want

Thanks Craige,

Yeah I know it is harder to see and attack the problem without having the full picture but some of the data is confidential and it is hard to minimize it or rename all of it. But I can tell you what I did.
I took my input csv and imported it manually with the wizard making sure to change the column of interest to character nominal. It imports correctly. Then I built a dashboard as well (simple one). I generated the dashboard script and copied the column import portion into my original script for the dashboard I was having trouble with.
I ran it again and still the same problem.