TRUE/FALSE data from Excel importing as 1/0After 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.
Data AccessMass CustomizationRe: TRUE/FALSE data from Excel importing as 1/0I 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" ) ) );
