Error Messages/40445
Error Message Examples
The optional valueColumn parameter (7th parameter) passed to MdTable was 'Yellow', which is not an element of the Column2D index.
Cause
The parameter passed as the valueColumn to MdTable contains an identifier that is not present in the parameter passed as the Cols parameter to the function. The valueColumn parameter is optional for 2 dimensional table in pure-relational format, and should be a subset of the parameter passed as the Cols parameter.
An example of the two 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'];
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