281634_en-US

liliconcom

How to make Col List Box Report only specific data type

try to make a column list box so the user can select parameters for analysis. 

Want to limit to column with data type "character" in this col list box.  Use the script below but it report all columns.

 

nw = new window("Select Parameter for Pareto",
borderbox(left(3),top (2),
		hlist box(
			textBox("Select Group for Yield Analaysis"),
			hlistbox(
				vlistbox(
						panelbox("Select group",
						ColListData = collistbox( all, << set Data Type( "character" ));
						)
				)
			),
			panelbox("Select Parameters",
				LineupBox(NCol(2),Spacing(3),
                        ButtonBox("Y, Columns", colListY<<APPEND></APPEND>

Advanced Statistical ModelingAutomation and ScriptingContent OrganizationMass CustomizationRe: How to make Col List Box Report only specific data type

Here is a rework of your code.  You had already limited the first Col List Box() to "Character", you just didn't use the correct syntax for the second Col List Box()

names default to here(1);
dt=open("$SAMPLE_DATA\big class.jmp");

nw = new window("Select Parameter for Pareto",
borderbox(left(3),top (2),
  hlist box(
   textBox("Select Group for Yield Analaysis"),
   hlistbox(
    vlistbox(
      panelbox("Select group",
      ColListData = collistbox( all, << set Data Type( "character" ));
      )
    )
   ),
   panelbox("Select Parameters",
    LineupBox(NCol(2),Spacing(3),
                        ButtonBox("Y, Columns", colListY<<APPEND></APPEND>

Re: How to make Col List Box Report only specific data type

try that but it still show all columns.

Re: How to make Col List Box Report only specific data type

Here are the options available to Col List Box, taken from the Scripting Inded

     Help==>Scripting index

It has options for  setting the data type and the modeling type