Difference between revisions of "Error Messages/40445"

Latest revision as of 00:37, 29 March 2016

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 Relational tables and multiD arrays that explain the function in more detail and provide 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.

@@ Line 1: / Line 1: @@
-= Error Message Examples =
+[[Category: Error messages]]
+== Error message examples ==
+<pre style="background:white; border:white; margin-left: 1em;">
   The optional valueColumn parameter (7th parameter) passed to MdTable was 'Yellow',
   which is not an element of the Column2D index.
+</pre>
-= Cause =
+== 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.
+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:
+An example of the two parameters for a 2 dimensional table with the columns <code>'IndexA', 'IndexB', 'Red', 'Green'</code> and <code>'Blue'</code> would be as follows:
-<code><br>
+:<code>Cols parameter := ['IndexA', 'IndexB', 'Red', 'Green', 'Blue'];</code>
-Cols parameter := [ 'IndexA', 'IndexB', 'Red', 'Green', 'Blue' ];<br>
+:<code>valueColumn parameter := ['Red', 'Green', 'Blue'];</code>
-valueColumn parameter := ['Red', 'Green', 'Blue'];<br>
-</code>
-The documentation on [[MdTable]] and the Analytica User Guide explains the function in more detail and provides [[Mdtable#Examples|examples]] on how the function can be used.
+The documentation on [[MdTable]] and [[Relational tables and multiD arrays]] that explain the function in more detail and provide [[Mdtable#Examples|examples]] on how the function can be used.
-= Remedies =
+== 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
+# 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.
+# Add the [[identifier]] specified in the error to the «Cols» parameter to the [[MdTable]] function.
-<br><comments />
+==See Also==
+* [[Function calls and parameters]]
+* [[Function parameter qualifiers]]
+* [[Relational tables and multiD arrays]]
+* [[Arrays and Indexes]]
+* [[MdTable]]
+* [[identifier]]