USE Rows

Add Table(s) in Setup|Tables has a USE Rows option that lets you use already-created rows in a new table; you can ‘borrow’ text, logic and the Table title from existing tables.

For example, say you're creating 20 tables based on the same satisfaction rating scales for 20 different brands; the rows for all 20 tables will be ‘Use Every Day,’ ‘Use Sometimes’ and ‘Never Use’. Rather than having to enter the text and logic for each row, you can create the first table, then use USE Rows to quickly specify the rows for all 19 of the other tables.

To use this option:

• Select Setup|Tables.
• In the Tables list box, select the table that has the rows you want to duplicate, then choose Add Table.
• USE Rows lets you copy from the chosen table and from any table preceding that table in the list box.

  Express Table Editor also has USE Rows options.

USE Rows

The USE Rows dialog box displays information for existing tables. It shows information for the table you highlighted in the Tables list box and for all tables before that table.

Tables

The Tables list box displays the tables from which you can choose rows. Choose the desired table. If the table you want is not included, exit USE Rows and highlight that table in the Tables list box of Setup|Tables.

Rows

Rows lists the rows available for the currently selected table. Select another table in the Tables list box to view rows for that table.

For Variable files:

Variables (rather than Logic positions)

The Variables list box displays all the variables for the selected table. Many tables are based on just one variable, but if there are multiple variables they are all displayed.

Variable increment (rather than Position increment)

• You can use Increment to define new variables that are contiguous or in the same order as the existing variables.
• Select Increment to increment the displayed variable. If you want to increment by more than one variable, first enter that factor in the Variable increment field.
• When there is more than one variable for a table, Increment affects all those variables.
• Only the first variable in a row can be incremented. For rows that have more than one variable connected by an operator (for example, AND) only the first variable is incremented. To avoid such situations, use the Glossary Variable commands to create a variable that represents both positions. Then Increment will affect all positions represented by the variable.
• USE Rows automatically applies the proper field width and any Scan (S) or Everywhere (E) notations that were used to define the variable.
• If you want to define a new variable that is not contiguous or not in the same order as the old variable, double-click on the old variable in the Variables list box. The Edit USE Logic dialog box opens and you can enter new logic.

USE statement:

You can modify the USE statement logic here.

Generate USE statement from:

Allows you to create USE tables that use the Table name, when possible or the Table index of the selected tabled in the USE statement generated by WinCross.

• Table name, when possible is the WinCross default.
• Table names can only be used in USE statements when the table name is alphanumeric.
• If the table name is numeric, WinCross will use the Table index when generating USE statements.

For ASCII files:

Logic positions

The Logic positions list box displays all the logic positions (record/column) for the selected table. Many tables are based on just one record/column position, but if there are multiple positions, they are all displayed.

Position increment

• Use Position increment to define new logic positions that are contiguous or in the same order as the existing logic positions.
• Select Increment to increment the displayed position. If you want to increment by more than one column position, first enter that factor in Position increment.
• For example, if the current position is 1/4 and the Position increment is 1, Increment changes the position to 1/5. If the Position increment is 2, Increment changes position 1/4 to 1/6.
• When there is more than one position for a table, Increment affects all those positions.
• Only the first position for a row can be incremented. For rows that have more than one position connected by an operator (for example, AND), only the first position is incremented. To avoid such situations, use the Glossary Variable commands to create a variable that represents both positions. Then Increment will affect all positions represented by the variable.
• USE Rows automatically applies the proper field width and any Scan (S) or Everywhere (E) notations that were used to define the original position.
• If you want to define a new logic position that is not contiguous or not in the same order as the old logic position, double-click on the old logic position in the Logic positions list box. The Edit USE Logic dialog box opens and you can enter new logic.

USE statement:

You can modify the USE statement logic here.

Generate USE statement from:

Allows you to create USE tables that use the Table name, when possible or the Table index of the selected tabled in the USE statement generated by WinCross.

• Table name, when possible is the WinCross default.
• Table names can only be used in USE tables when the table name is alphanumeric.
• If the table name is numeric, WinCross will use the Table index when generating USE statements.

More about USE Rows:

• The Table title of the original table is assigned to the new tables created by USE Rows. The Table title for the new tables can be edited in the Table title field.
• A table created by USE Rows cannot have its row text edited.
• When you select a table that was created using USE Rows, the logic indicates the table name or table index (for example, USE=Q2A or USE=3) and the row options cannot be selected (the buttons are grayed out) on the Setup Tables dialog box.
• You can make changes to filters, table options and table statistics.

Advanced Features for USE Rows:

The basic USE Rows procedure substitutes variables (or record/columns) from the used table each time the variable (or record/column location) changes.

You can use an advanced method, substituting variable names or record/column values. However, one statement cannot use both methods. The advanced method lets you specify the variable name or record/column from the used table, an equal sign (=) and then the variable name or record/column you want substituted for it in the new table:

USE = table name, used variable=new variable, used variable=new variable...

or

USE = table name, used record/col=new record/col, used record/col=new record/col...

USE = table index, used variable=new variable, used variable=new variable...

or

USE = table index, used record/col=new record/col, used record/col=new record/col...

The order of the variable or record/columns in the table being used is not important. The variable or record/column specified on the right of an equal sign is substituted for the variable or record/column from the table being used on the left side of the equal sign, even when complex logic statements are included. Variables or record/columns in the table being used that do not have a match in the USE statement are used ‘as is’ in the new table.

Example 1 (variable data):

If the logic in the table being used is:

{Q3_1 (6) AND Q5_1 (3,4)} AND NOT Q4_1 (2)

And the USE Rows statement is:

USE=Q3A,Q3_1=Q3_2,Q4_1=Q4_2,Q5_1=Q5_2

The result would be:

{Q3_2 (6) AND Q5_2 (3,4)} AND NOT Q4_2 (2)

Example 2 (ASCII data):

If the logic in the table being used is:

 {1/25 (6) AND 1/29 (3,4)} AND NOT 1/27 (2)

And the USE Rows statement is:

 USE=1,1/25=1/40,1/27=1/42,1/29=1/44

The result would be:

 {1/40 (6) AND 1/44 (3,4)} AND NOT 1/42 (2)

USE Rows functions as a basic search and replace using the string on the right side of the equal sign (=) to replace the string on the left side of the equal sign (=).

Example 3 (variable data):

If the logic in the table being used is:

Q7 (99)

And the USE Rows statement is:

 USE=Q7,Q7 (99)={Q5A (28) OR Q5B (30)} AND Q7 (99)}

The result would be:

{ {Q5A (28) OR Q5B (30)} AND Q7 (99)}

As with the basic USE Rows feature, you do not specify width (:), the Scan (S) feature or the Everywhere (E) feature, since these are specified in the table being used and are automatically included when the USE Rows statement is interpreted.

Writing the Advanced Statement:

Write the advanced statement similar to the way you use the basic feature. From Setup|Tables, select Add Table and select USE Rows. Select a table to use. Do not increment the variable or record/column position(s). Choose OK to go back to the Add Table dialog box, then choose OK again to return to the Setup|Tables dialog box.

The Row edit box displays the current logic, for example:

USE=10,Q1_1,Q2_1,Q3_1

or

USE=10,1/25,1/26,1/27

Enter the desired equivalencies in the Row logic field, for example:

USE=Q1,Q1_1=Q4_1,Q2_1=Q5_1,Q3_1=Q6_1 

or

USE=Q1,1/25=2/30,1/26=2/31,1/27=2/32

Substituting code values:

You can also use equivalencies for substituting code values. Do this with caution: do not specify an equivalence that affects areas other than those you want to substitute.

For example, say you have a top-two box summary table with 50 attributes and three of those attributes are:

Now you want to create a bottom-two box summary table of the same 50 attributes. You can use an equivalency statement to avoid retyping labels or logic. For example, you can simply enter:

 USE=Q1,(4,5)=(1,2)

There are no variable or record/column specifications in the statement. You want to use the same variables or record/columns, so it is not necessary to reference them. The above statement means, ‘Substitute (1,2) for (4,5).’ If you were to write out these rows, the logic would be:

Substituting characters in row logic:

You can also substitute all or part of row logic with the use of double quotation marks.

For example, you may have a table defined as:

You want to use the same Attribute descriptions (row text). The only part of the logic that is different is a portion of the variable names for the USE table (Q1_TECHNICAL_SUPPORT, Q2_TECHNICAL_SUPPORT AND Q3_TECHNICAL_SUPPORT).  You only need to substitute "SALES" with "TECHNICAL". Your USE statement would look like this:

USE=Q1,"SALES"="TECHNICAL" (where Q1 is a table name)

or

USE=10,"SALES"="TECHNICAL" (where 10 is the index number of the Q1 table)

For the USE table, the logic of Q1_SALES_SUPPORT (1) will become Q1_TECHNICAL_SUPPORT (1), Q2_SALES_SUPPORT (1) will become Q2_TECHNICAL_SUPPORT (1), etc.

You can use this substitution along with the other methods described above. For example:

USE=Q1,(4-5)=(1-2),"SALES"="TECHNICAL" (where Q1 is a table name)

or

USE=10,(4-5)=(1-2),"SALES"="TECHNICAL" (where 10 is the index number of the Q1 table)

Related topics:

Add Table(s)

Setup Tables