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.
Choose Language Hide Translation Bar
View Original Published Thread

excel import + columns with drop-down menus

Françoise
Level V

Good morning,

 

I have an Excel file that I want to import with JMP.

there are columns with a choice of value for the cell

undefined

 

Jmp does not import any value (empty column in Jmp).

 

is there a solution?

 

Sincerely

This post originally written in French and has been translated for your convenience. When you reply, it will also be translated back to French .

1 REPLY 1
Françoise
Level V

Re: excel import + columns with drop-down menus

Good morning,

 

the solution I found:

in excel: the column did not have a format specified.

I set the column in text format and >Jmp then imports the values.

 

Sincerely

 

Francoise

This post originally written in French and has been translated for your convenience. When you reply, it will also be translated back to French .