Importing code table results in display of ID numbers, not code values
When coded values are defined by importing a seperate table of code values and
definitions (in the DPW), the attribute info (next to "measurement domain")
displays ID numbers referencing the information in that table of codes, but
does not display the code definitions themselves. Therefore the person looking
at the attribute info for a column sees a long string of numbers (which have no
meaning to the user) instead of the information they need, namely, what do the
This bug was discovered by Veronique.
Updated by Saurabh Garg almost 19 years ago
To remove the reference numbers in this case, Morpho will have to read the data
I have figured out a way to do this in Java - when the user selects code and
definition, the code and definitions can be added to the column metadata
instead of adding references to the selected entity. The problem here is that
we are carrying redundant information. So if the user modifies the data file
(e.g. add more codes) - the column metadata and data file no longer have the
same data in it.
Another way might be to modify these in XSL - so that realtime parsing of data
is done to show code and definitions. But this will be complex because data
will have to be read from XSL which is dependent on factors like precense of
data, format of data etc.
The first option can be coded easily if the problem described above is not
considered a significant one.