DataSet MVIndicator - Column with Spaces | trent | 2012-06-07 22:34 |
Status: Closed | ||
Ran into this issue the other day. After attempting to import a dataset, that contains the 'N' character and with a column header containing a space, will get the error: ERROR: column cc.space field_MVIndicator does not exist Position: 211. Some obvious solutions are to change the missing value indicator value - https://www.labkey.org/wiki/home/Documentation/page.view?name=manageMissing, or remove spaces from header when creating datasets. (i.e. when creating a dataset that may contain missing value indicators, to ensure the header has no spaces) By the way, I believe the actual problem is in the construction of the SQL query, because the field has a space, it is being enclosed in quotes. As a result, it is case sensitive. At least in postgres, the column is all lower case. (Only applies for create wizard. I don't think missing value indicators are obeyed on import data functionality.) |
||