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
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'];
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'];
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:
- Remove the identifier specified in the error from the valueColumn parameter. OR
- Add the identifier specified in the error to the Cols parameter to the MdTable function.
Enable comment auto-refresher