Review: "Trust, Automation, Reliance...TIBCO Spotfire."
TIBCO Cloud Spotfire
Spotfire's recommendation engine would automatically detect if new data should be added as rows to existing data. With Spotfire 7.9, the recommendation engine for add rows also automatically matches columns with common names but different prefixes and/or postfixes. For example, the new column 'Sales (2016)' will match the existing column 'Sales (2015)'. This is a significant change to SQL data entry.
Columns that have the same prefix/postfix will have the prefix/postfix removed from the column name. In the example above, the column name will be 'Sales'. Once again a clear example of excellent data wrangling.
The prefix/postfix will automatically be entered on all rows in the origin column. In the example above, the origin column will contain '2016' and '2015' for the respective data sources~ Improvement over companies that have comparable prefix/postfix automation implementation algorithms.