Choose Language Hide Translation Bar
Highlighted
segaqaci
Level I

Table Scripts

Hello. I have saved some scripts that I would like to use when I perform outlier analysis. These are Fit Model scripts and I want to run 1 script every time I use a loop to hide and exclude a value. However, I have named the scripts as per column names. So I want the script name to match the column name and run only that script. I have considered an example of the Linnerud sample data.

dt = current data table();
col = dt << get column names( string );
nc = N Items( col );
For( i = 1, i <= nc, i++,
 If( Contains( ColNames[i], "Outlier" ),
 Col1 = Column(dt,i);
 max = data table(dt);
 max << select where(as column(Col1)==abs(Col Max( Col1 ))) << Hide and Exclude;
 //Hide and exclude the MAX val from Outlier 1 Rest Pulse, and Run Outlier 1 Rest Pulse script
//Run Script("Outlier 1 Rest Pulse");
 )
 );

Is this possible?

 

 

 

https://newpornsites.pro
great xxx sites list for free
1 REPLY 1
Highlighted
txnelson
Super User

Re: Table Scripts

Yes it is possible.  Below is an update to your code.

Names default to here(1);
dt = Current Data Table();
col = dt << get column names( string );
nc = N Items( col );
For( i = 1, i <= nc, i++,
	// Clear the Hide and Excludes from the last loop
	dt << clear rowstates;
	If( Contains( Col[i], "Outlier" ),
		Col1 = Column( dt, i );
		dt << select where( As Column( Col1 ) == Abs( Col Max( Col1 ) ) ) << Hide and Exclude;
 //Hide and exclude the MAX val from Outlier 1 Rest Pulse, and Run Outlier 1 Rest Pulse script
		//Run Script("Outlier 1 Rest Pulse");
	)
	// Make sure Auto Recalc is unselected in the platforms you run, since if it is active, all
	// the platforms will recalcuate to new results each time the different Hide and Excludes are changed
);
Jim
Article Labels

    There are no labels assigned to this post.