Difference between revisions of "Input Data Format"
Line 12: | Line 12: | ||
* '''Header''': Check if the file have a ''Header row'' that identifies the columns (The header will be used as the initial name for the columns in the data source, but you can change it); | * '''Header''': Check if the file have a ''Header row'' that identifies the columns (The header will be used as the initial name for the columns in the data source, but you can change it); | ||
+ | |||
+ | * '''Decimal Separator''': Specifies the decimal separator used in the file. For CSV files only | ||
Revision as of 20:29, 4 July 2013
File:Data source data format.png
- Date mask: Choose the Date fields mask in the file. The selected mask must be exactly equal to the format used by dates in the file. For CSV files only;
- Start row: Specifies which row of the file the import process should start reading. Headings should be included if the Header row option is checked. For CSV files only;
- Delimited by: Specifies the columns delimiter character. Select between Tab, Semicollon, Collon or Other character (for Other type the desired delimiter in the field). Usually the correct option is selected automatically. For CSV files only;
- Header: Check if the file have a Header row that identifies the columns (The header will be used as the initial name for the columns in the data source, but you can change it);
- Decimal Separator: Specifies the decimal separator used in the file. For CSV files only
- Columns options: Click the column header in the preview table to select and change its options:
Click the Next button.
See Automatic Dashboard Generation for information on how to continue.
If you are updating a data source, go directly to the import summary.