topic Excluded Cols still plotting when I run a script, but not when I plot it manually? in Discussions

Excluded Cols still plotting when I run a script, but not when I plot it manually?

aliegner1 — Fri, 09 Jun 2023 19:51:19 GMT

So not sure what to is going on here. I'm trying to plot this Group of cols, with several excluded. If I manually launch the FitYbyX, those excluded columns don't even show up in the pop-up and thus don't get plotted. However, when I run this script telling it to plot that Column Group, it still plots the excluded Columns. What's up with this?

dt= current data table();

ow2 = Oneway(
	Y( dt<<get column group( "TestGroup" ) ),
	X( :chamber_id )
	);

Re: Excluded Cols still plotting when I run a script, but not when I plot it manually?

txnelson — Thu, 01 Jul 2021 02:45:44 GMT

I have replicated your finding. I suggest you pass this issue to the JMP Support team. You also may want to add the need to honor excluded columns to the JMP Wish List.

All that said, here is a work around

names default to here(1);
dt= current data table();

colList = dt<<get column group( "TestGroup" );

// Remove from the group list excluded columns
for(i=nitems(colList),i>=1,i--,
	if(column(dt,colList[i])<<get excluded == 1,
		remove from(colList,i,1)
	)
);

ow2 = Oneway(
	Y( eval(colList) ),
	X( :site )
	);

Re: Excluded Cols still plotting when I run a script, but not when I plot it manually?

Mark_Bailey — Thu, 01 Jul 2021 17:39:23 GMT

The excluded attribute of a data column is intended to remove it from the column lists in launch dialogs so it cannot be selected. It is not intended to exclude it as a variable from analysis, so when you put a column group in an analysis role, you are selecting all the columns in that group. Selecting the group over-rides the exclusion from selection.