This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
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: 
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 07:24 PM (939 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
mzwald
Staff mzwald
Staff

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

Created: Dec 27, 2020 02:59 AM  |  Last Modified: Jan 3, 2021 05:07 PM (910 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" ) ) );