Changes

Jump to: navigation, search

Excel Importing Guide/en

495 bytes added, 02:28, 5 October 2022
Updating to match new version of source page
As instruções abaixo irão ajudá-lo a formatar corretamente seus arquivos Excel para importação no TaticView.<languages/>
The instructions below will help you make sure your Excel file is formatted correctly to be imported as a TaticView datasource.  '''É possível baixar um arquivo de exemplo formatado corretamente emYou can download a sample file here: '''[[httpSpecial://wiki.taticview.com/taticfilesFilePath/Sales.xlsx |Sales.xlsx]]'''
'''If you still have problems importing, try [[Importing Problems]].'''
'''CabeçalhosHeaders'''
Cabeçalhos não são obrigatóriosHeaders are not mandatory, mas se estiverem presente devem estar em uma única linha but if present they should be contained in just one row (a primeirathe first one) e não estarem em células mescladasand not be in merged cells.
'''Evite Múltiplas TabelasAvoid Multiple Data Tables'''
Only one table by spreadsheet can be imported. If the data in two different tables can not be joined, they must be imported as two separated data sourcesdatasources.
'''CorrijaFix/Remova LinhasRemove Empty Rows/Colunas VaziasColumns'''
Remova ou corrija Remove or Fix (adicionado ao menos um cabeçalhoby adding at least a header) linhas e colunas totalmente em brancoto full empty rows and columns.
'''Remove Merged Cells'''
Os dados não devem estar contidos em células mescladasData should not contain merged cells for repeated values. Todas células devem ser separadas e os valores repetidos para cada célulaAll cells must be unmerged and values must be repeated for each cell.
'''Remova Linhas TotalizadorasRemove Aggregate Rows'''
Files should not contain aggregation rows cells for repeated values. Delete that rows, as TaticView will make all necessary aggregations in run-time.
'''Remova Elementos ExternosRemove All Table External Items'''
Os arquivo a serem importados devem conter apenas a tabela de dadosFiles should only contain the data table to be imported. Toda informação não relacionadaAll non-related data, como informaçõesas main headers, imagensimages, gráficos devem ser removidos antes da importaçãocharts, must be removed prior to importing.
'''Check for Invalid Numeric Data'''
Colunas numéricas devem ser formatadas de acordo no Numeric columns should be formatted in Excelprior to uploading the file. Campos numéricos (de valor) não podem conter textos ou símbolosThis can be done by using the “Convert to number” feature in Excel for all numeric fields. [[Value]] data fields can not contain text or symbols, as they cannot be aggregated. Células sem When datais not available, devem estar em branco ou com cells may be left blank or as zero (0).
'''Normalize seus Dadosyour Data'''
Normalization of data (where column headers can be converted into attribute values) will result in better analysis. To do this, first convert metric names to represent attribute values, and then consolidate all metric columns into a single column of data.
[[File:normalization_wrong.png|link=]] [[File:normalization_right.png|link=]]
 
 
'''Check the order of the worksheet'''
 
If the file (XLS or XLSX) has more than one worksheet (tab), make sure that the worksheet to be imported is the first one in the file. TaticView considers only the first worksheet (tab) of the file, ignoring the others. In the example below, we show how the order of the worksheets should be, so that we can import the '''Sales''' worksheet.
 
[[File:spreadsheet_order_wrong.png|link=]] [[File:spreadsheet_order_right.png|link=]]
FuzzyBot
11,856
edits
Retrieved from "http://wikidev.taticview.com/index.php/Special:MobileDiff/6038...29864"

Navigation menu