Error Messages/40446

Error message examples

 In the call to MdTable, you have specified that the second column of Column2D, 'IndexB',
 is to be used as the value column.  However, in the fourth parameter, Vars, you have listed
 2 indexes, which indicates that the first 2 columns along the Column2D index are to be used
 as coordinates.  The number of indexes listed in the fourth parameter must be reduced to 1
 or less, or 'IndexB' cannot be used as a value column.

Cause

The concatenation of the «Vars» and «valueColumn» parameters to the MdTable should be a subset of the «Cols» parameters passed to the function. The size of the concatenation of the two parameters is larger than the size of the «Cols» parameter. So,

• You have either missed an identifier in the «Cols» parameter.

OR

• You have an extra identifier in either «Vars» or «valueColumn» parameter to MdTable.

An example of the parameters for a 2 dimensional table with the columns 'IndexA', 'IndexB', 'Red', 'Green' and 'Blue' would be as follows:

Cols parameter := ['IndexA', 'IndexB', 'Red', 'Green', 'Blue'];
valueColumn parameter := ['Red', 'Green', 'Blue'];
Var parameter := ['IndexA', 'IndexB'];

And, the following would trigger this error:

 
Cols parameter := ['IndexA', 'IndexB', 'Red', 'Green', 'Blue'];
valueColumn parameter := ['IndexB', 'Red', 'Green', 'Blue'];
Var parameter := ['IndexA', 'IndexB'];

The documentation on MdTable and the Analytica User Guide explains the function in more detail and provides examples on how the function can be used.

Remedies

Study the columns of the 2 dimensional table you are trying to convert and either:

1. Add the missing identifier to the «Cols» parameter.
2. Remove the extra identifier in the «Vars» or «valueColumn» to MdTable function.

See Also

• Function calls and parameters
• Function parameter qualifiers
• Relational tables and multiD arrays
• Arrays and Indexes
• MdTable
• identifier
• Concat