DataSet MVIndicator - Column with Spaces

LabKey Support Forum (Inactive)
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.)