User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
geneticjunkie
geneticjunkie
Level I

TRUE/FALSE data from Excel importing as 1/0

Created: Dec 26, 2020 02:49 PM  |  Last Modified: Jun 10, 2023 4:24 PM (2806 views)

After recently upgrading to JMP15, all of my TRUE/FALSE data columns are importing from Excel as Numerical 1/0 instead of text. I have searched and can't find a preference or setting for this. How do I make sure the columns import as TRUE/FALSE? This didn't happen in JMP14.

0 Kudos
1 REPLY 1
Mark_Zwald
Staff Mark_Zwald
Staff

Re: TRUE/FALSE data from Excel importing as 1/0

Created: Dec 27, 2020 02:59 AM  |  Last Modified: Jan 3, 2021 2:07 PM (2777 views)  |  Posted in reply to message from geneticjunkie 12-26-2020

I noticed when opening an Excel file with the JMP Excel add-in, Boolean values get imported as numeric, but if opening the Excel file through the Excel Import Wizard or copy/paste from Excel to JMP, the Boolean values become text. Converting the numeric values to text is straightforward enough through Recode column utility or using a formula.

Ex. dt << New Column( "Boolean Text", Formula( if( :flag == 1, "TRUE", "FALSE" ) ) );

Recommended Articles