2.2.3.71 wstackcol

1 Menu Information
2 Brief Information
3 Command Line Usage
4 X-Function Execution Options
5 Variables
6 Related X-Functions
7 More Information

Menu Information

Restructure: Stack Columns

Brief Information

Stack data from multiple columns using group identifiers

Command Line Usage

1. wstackcol irng:=(col(1):col(2)) tr.identifiers:={G};

2. wstackcol irng:=(1:end) tr.identifiers:={L} gln:=Class;

3. wstackcol irng:=(col(b):end) include:=col(a) method:=1 gln:=Group;

4. wstackcol irng:=(2:end) tr.identifiers:={L, U} include:=col(1) groups:=2 method:=1 gln:=Class;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display Name	Variable Name	I/O and Type	Default Value	Description
Input Stack Column(s)	irng	Input Range	<active>	Specify at least two columns for the source data.
Group Identifier	tr	Input TreeNode	<unassigned>	This is a tree for group identifier settings. identifiers: Group Row(s) Select the column label rows which contain the group information. With this information, the tool identifies the group to which the samples belong. In the GUI, the text box will list all the column label rows (including User Defined Parameter) in the original worksheet. This allows the selection of multiple rows. Possible options include the following, depending on whether the label row is shown in the original worksheet: Short Name Use the column's Short Name as grouping identifier. Long Name Use the column's Long Name as grouping identifier. Units Use the column's Units as grouping identifier. Comments Use the column's Comments as grouping identifier. UserDefined Use the column's User Defined Parameter as grouping identifier. If there are multiple rows selected in the Group Row(s) text box, the selected order of the groups will show in the lower text box. When scripting, you must specify the standard column label row characters with brackets (e.g., `tr.identifiers:={L, U}` means Long Name and Units label rows are used as group identifier; for Short Name, use `G`).
Include Other Column(s)	include	Input Range	<optional>	Specify whether to include other column(s) in the output. With this selected, you can pick the columns to be included.
Stack into Subgroups	groups	Input int	2	Specify whether to stack the original samples into several subgroups. If this is not selected, all of the input samples will be stored in one column only. With this selected, you can specify the number of subgroups, or the number of columns into which the samples are stacked. Suppose there are six groups in the original data and you choose to stack them into two subgroups. The first, third, and fifth groups will be in the first subgroup, while the rest will be in the second.
Stack by Rows	method	Input int	0	Specify whether to interlace samples from different groups. Suppose there are two groups in the original dataset and this option is selected. The even rows in the output column will be samples that belong to the first group, while the odd rows will be samples from the second group. If this is not selected, the first n rows in the output column (n is the number of samples in the first group) will contain the samples from the first group, while the rest of the rows will contain the samples from the second group.
Exclude Missing Rows	exclude	Input int	0	Specify whether to ignore rows with missing values in the source columns.
Group Column Long Name	gln	Input string	<Group Row Header>	Specify the long name for the group column. Options include: <Group Row Header> The row header from which the group information is taken. See Group Identifier, above. Group Show the Group string with an enumerated number, such as "Group1", "Group2", etc. Class Show the Class string with an enumerated number, such as "Class1", "Class2", etc. You may also use a custom string with an enumerated number for the Long Name.
Data Column Long Name	dln	Input string	Data	Enter the Long Name for the output data column. The Long Name will be enumerated.
Output Worksheet	ow	Output Worksheet	<new>	Specify the worksheet for outputting the results.