Is there a list of keywords that IBM Watson Analytics uses in column headers to try to determine properties? Could “Gross” be a keyword for currency? Once set in Watson Analytics, it doesn’t appear to be converted.
For example, look at the out-of-the-box “TRIRIGA Buildings & Space Allocation Data” set. Gross Area shows as currency ($). Others are too: Area/Occupant (Gross), Gross Rentable. But not all number columns are, ones that don’t include “Gross”. The UOM doesn’t appear to be defined in the properties, so it seems like it must be using the column header? I haven’t tried changing the header, but as-is, once exported, is there a way for that column to show correctly as an area instead of currency?
This question is best suited for the IBM Watson Analytics forum. There are posts on that forum that indicate that Watson Analytics does look at column names when deciding whether to add currency values, but I did not see a list of all the special keywords. Other than changing the column name before upload, I don’t know of a way to override those special keywords or modify the UOM that Watson Analytics assigns in the data set. So these questions will be better answered in the Watson Analytics forum. That forum is also the place where you can suggest enhancements around this Watson Analytics behavior.
[Admin: This post is related to the 12.15.16 post about finding information about the IBM TRIRIGA Connector for Watson Analytics, and the 11.15.16 post about the overview and demo. To see other related posts, search “Watson Analytics“.]