Data Transformations in Connect

Spreadsheets and databases often contain negative or blank values, and Connect has always imported the data as-is. Usually this is just fine, but occasionally people have wanted to tweak the data while it's being imported.

The latest version of Connect now lets you do just that. The options for negative or missing values are to "Allow", "Ignore", "Interpret as Zero", or "Set to N/A".