cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
BabyDoragon
Level II

How to use Column() to convert multiple items?

In the following JSL, I want to delete columns using a List method. However, when selecting multiple options, only the first selected item is deleted. This is because Column() cannot handle the conversion of multiple column names selected.
Is there a more straightforward way to achieve the deletion of multiple items besides using a For loop to delete each column one by one?

dt = Open( "$SAMPLE_DATA/Employee Master.jmp" );
col_list = dt << get column names( string );
New Window( "Delete exist Column",
	H List Box(
		columnList = List Box( col_list ),
		Button Box( "Delete Column",
			dt << delete column(  Column( dt, columnList << GetSelected ) );
			columnList << Remove Selected( columnList << GetSelected );
		)
	)
);
1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: How to use Column() to convert multiple items?

Don't use Column() and just use the list of columns with << Delete Column

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Employee Master.jmp");
col_list = dt << get column names(string);
New Window("Delete exist Column",
	H List Box(
		columnList = List Box(col_list),
		Button Box("Delete Column",
			dt << delete columns(columnList << GetSelected);
			columnList << Remove Selected(columnList << GetSelected);
		)
	)
);
-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: How to use Column() to convert multiple items?

Don't use Column() and just use the list of columns with << Delete Column

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Employee Master.jmp");
col_list = dt << get column names(string);
New Window("Delete exist Column",
	H List Box(
		columnList = List Box(col_list),
		Button Box("Delete Column",
			dt << delete columns(columnList << GetSelected);
			columnList << Remove Selected(columnList << GetSelected);
		)
	)
);
-Jarmo

Recommended Articles