I would like to remove values from a column. Normally, I would use a range check column property to do this, but with this particular column, it is also dependendent on another column's value. Is there an easy way to do this?
I tried the code below, but unfortunately it makes the entire column blank except for the first row. I thought this might work because the "." represents missing values. The data and modeling types are numeric and continuous.
I found a way to make it work, but I don't know how efficient it is. I saved the values from the columns to lists, deleted the one column, made a new column, and added the passed values to the new column. If it wasn't a passed observation, it wasn't add and the entry in that cell is simply a "."
idList = List(); idList = As List(:Col X<< get values); idLogic = List(); idLogic = As List(:Col Y<<get values);