How do I automatically exclude rows including outliers as identified by the "Explore Outliers" function?Hi there,
I am looking to replicate what I do manually in JSL script.
I know how to run the "Explore Outliers" function in JSL but I still have to manually select the rows with outliers identified by the "Explore Outliers" then press 'select rows' then press 'exclude'.
I am trying to build a script which I run and automatically excludes the outliers identified without me having to do anything else (ideally does not even open up the Explore Outliers window.
Anyone got any ideas?
Thanks!
ScriptingRe: How do I automatically exclude rows including outliers as identified by the "Explore Outliers" function?Which outlier method are you selecting when you run Explore Outliers? It appears that different solutions may be required for the different methods.Re: How do I automatically exclude rows including outliers as identified by the "Explore Outliers" function?I am using the quantile range outliers method - sorry forgot to say in the original post!Re: How do I automatically exclude rows including outliers as identified by the "Explore Outliers" function?Hi @JC7 ,
Should be pretty easy following something like this:
Names Default To Here( 1 );
dt = Current Data Table();
colnames = dt << Get column Names();
obj = dt << Explore Missing Values( Y( Eval( colnames ) ) );
obj << select rows( Eval( colnames ) );
DS
