Valid Labels and Values for Spreadsheet/CSV Mashables
Some labels and data that are valid in CSV files or Excel spreadsheets are not valid or not accessible in Business Analytics. In the following cases, Business Analytics may alter labels or transform or ignore the information:
Formulas in spreadsheets are valid, but the formula itself is not exported to the mashable in
Business Analytics. The result of the calculation (the data) is exported instead.
Column labels:
Are recommended, but optional, for each column that contains data.
If column labels are missing, Business Analytics automatically generates labels in the form Column1, Column2 and so on.
Are limited to letters, numbers and underscores in the ISO-8859-1 character set, also known as Latin 1.
Spaces and most symbols or punctuation characters are either converted to an underscore or ignored.
Must start with a letter (an alphabetical character) although they can contain numbers after that. Column labels that do not start with a letter are altered or overridden.
If a column label starts with a number or is a formatted date,
Business Analytics adds a prefix of
Column_ to the label.
Can only be provided by
one row. For CSV files, this must be the first row.
For spreadsheets you can identify which row supplies the column labels when you register the mashable. If your spreadsheet has column names in two or more rows, you must choose a single row, allow Business Analytics to generate column labels or simplify your worksheet.
Cannot span two or more cells in a spreadsheet.
Business Analytics treats the second and subsequent columns as missing labels. You can allow
Business Analytics to generate column names for the second and subsequent columns or you can update your worksheet.
Charts, images or other objects in spreadsheets are ignored and not saved in mashable data.
