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:
- Add the missing identifier to the Cols parameter. OR
- Remove the extra identifier in the Vars or valueColumn to MdTable function.
Enable comment auto-refresher