Open main menu

TaticView β

Changes

Input Data Format

428 bytes added, 14:25, 30 September 2022
no edit summary
[[File:data_source_data_format.png]]<languages/>
* '''Charset'''<translate><!--T: Choose the file charset between ''UTF1--8'' and ''ISO 8859>[[File:Formatação dos dados+en-1''US. Usually the correct option is selected automatically;PNG|link=]]
<!--T:2-->* '''Start rowCharset''': Specifies which row of the file the import process should start readingcharset. Headings should be included if Usually, the ''Header row'' correct option is checkedautomatically selected. For CSV files only;
<!--T:3-->
* '''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;
<!--T:4-->* '''Delimited byDate mask''': Specifies Choose the [[Date]] fields mask in the columns delimiter characterfile. Select between ''Tab'', ''Semicollon'', ''Collon'' or ''Other character'' (for ''Other'' type The selected mask must be exactly equal to the desired delimiter format used by dates in the field)file. Usually the correct option is selected automaticallyFor CSV files only;
<!--T:5-->
* '''Delimited by''': Specifies the columns delimiter character. Select between ''Tab'', ''Semicolon'', ''Collon'' or ''Another character'' (for ''Other'' type the desired delimiter in the field). Usually, the correct option is selected automatically. For CSV files only;
<!--T:6-->* '''Header''': Check if the file have has a ''Header row'' that identifies the columns (. The header will be used as the initial default name for the columns in the data source, but you can change it)datasource;
<!--T:7-->
* '''Decimal Separator''': Specifies the decimal separator used in the file. For CSV files only
<!--T:8-->* '''Columns options''': Left click Click the column header in the preview table to select and change its options:
** '''Column data type''': Specifies the column data type: [[Date]], [[Text]] or [[Value]];
** '''Column name''': Specifies the column name.;
** '''Decimal places''': Specifies how many decimal places. For [[Value]] columns only;
<!--T:9-->
Click the ''Next'' button.
<!--T:10-->
See [[Automatic Dashboard Generation]] for information on how to continue.
<!--T:11-->If you are [[Import/Update data|updating]] a data sourcedatasource, go directly to the [[New Data Source Summary|import summary]].</translate>