Missing formula with data with missing value trained by Partition model, how to convert JSL into a form that can be used in JMP formula.
ab>=-14&P1>=174.1&EVk<34341 or Missing&xyz<214.98 or Missing&EVk<154 or Missing&P1>=1741
:ab >= -14 & :P1 >= 1741 & (:EVk < 154 | Is Missing( :EVk )) & (:xyz < 214.98 | Is Missing( :xyz ))
Here "AB", "P1" and "EVk" are Partition multiple times.How do can keep only valid parameters?
And how do automatically turn
"EVk<154 or Missing"
":EVk<154 | is Missing(:EVk)"?
Just save the prediction formula as a column formula after selecting the partition model.
So if you save the fitted partition model, it IS a column formula.
But I have tried to copy the leaf label formula and calculate it as a normal formula, which is wrong.
dt<<New Column("text",formula(:ab>=-14&:P1>=1741&:xyz<214.98 or Missing&:EVk<154 or Missing));dt<<run formulas;Column("text")<<deleteFormula;Wait(0);
Yes, that code is wrong. That code is not what is saved as a formula for the leaf labels. You incorrectly copied what you want from the formula and pasted the wrong code into your script.
Here is an example that copied the saved formula for the leaf labels verbatim and pasted it as the argument to the Formula() argument for the new column:
Names Default To Here( 1 ); // open an example dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); // create a new column for character data and populate it with formula based on a // previously saved formula for leaf labels. dt << New Column( "Text", Character, Formula( If( !Is Missing( :height ) & :height >= 63, If( !Is Missing( :height ) & :height >= 67, "height>=63&height>=67", "height>=63&height<67" ), "height<63" ) ) );
yes.I also know that can use the "prediction formula" directly.But this prediction formula is so global, so large, and so complex that it is inconvenient to use it in other files.
The "leaf label formula" is accurate, but the leaf label formula produced automatically by the "Partition" model cannot be used directly.
So I transferred these leaf label formulas to Excel using VBA to automatically convert them into a form that can be used in JMP formulas.
But this operation will use the whole process of operation can not be fully automated.
I think we're confused because the Leaf Label Formula column already has a formula behind it. You don't need to convert anything. Can you explain more clearly exactly the steps you want to do?
Since I got these leaf label formulas that were not used in the original file.
So I simply removed the formula from the leaf label formula column, got only the text, and lumped the text of the different leaf label formulas into a file.
These textual leaf label formulas are then used to calculate other data using JSL.So I have this problem of conversion.