How to force a new best guess a column (modeling type and data type)I am initiating a column as character containing empty values.
Later on, this column will be populated with data from a data base that can be any type. By having characters no transformation is done by JMP.
How can I force a new best guess via JSL?
ScriptingRe: How to force a new best guess a column (modeling type and data type)Here is how I would approach the issue. The simple description is to subset out the column in question, save it as a .csv file and then have JMP read in the column using the Best Guess capability and then moving the column back into the original data table.
names default to here(1);
// Createa sample data table
dt=New Table( "Example",
Add Rows( 2 ),
New Script(
"Source",
Data Table( "Untitled 7" ) << Subset( All rows, columns( :test ) )
),
New Column( "test",
Character,
"Nominal",
Set Values( {"01/28/2020", "09/14/2021"} )
)
);
// Separate out the column in question
dttest=dt<<SUBSET></SUBSET>Re: How to force a new best guess a column (modeling type and data type)JMP is somehow slow writing CSVs, and until JMP 16 also reading them.
I was expecting access to the method used in JMP when loading new files.
dt:column << Type(Best Guess)
