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:

1. Remove the identifier specified in the error from the valueColumn parameter. OR
2. Add the identifier specified in the error to the Cols parameter to the MdTable function.

Sort by date Sort by score

Enable comment auto-refresher

You are not allowed to post comments.