With JMp 19.x
issue #2b got fixed:
// Replace Missing with Previous Value
For Each( {irow}, Index( 1, N Row( Data Table( "Big Class Families" ) ) ),
{prev = Empty(), dt = Data Table( "Big Class Families" )},
If( Is Missing( dt:height[irow] ),
If( !Is Empty( prev ),
dt:height[irow] = prev
),
prev = dt:height[irow]
)
);
Unfortunately, the code is generated without Begin/End Data Update()
i'd guess: very slow for large data tables.
for comparison: Recode
-> here Begin/End Data Update is added by default.
// Recode column: height
Local( {dt},
dt = Data Table( "Big Class Families" );
dt << Begin Data Update;
For Each Row(
dt,
dt:height[] = Map Value( dt:height, {62, 66}, Unmatched( dt:height ) )
);
dt << Run Formulas;
dt << End Data Update;
);