Duplicate keys

In a hypercube, data is indexed by a list of indices, collectively known as a key. The indices may be strings, integers or date/time values. If more than one value exists in the CSV file for a given key, Minsky throws a “Duplicate key” exception. This exception gives you the option of writing a report, which is basically a sorted version of the original CSV file, with the errors listed at the beginning. You can open this report in a spreadsheet to see if data needs to be corrected or removed.

In the case where the data is correct, but there are still duplicate keys, such as the example in the previous section, the duplicate keys may be aggregated over by setting the “Duplicate Key action” option.