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: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

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 (2661 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 (2632 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