1,438
edits
Changes
no edit summary
<translate>
<!--T:1-->The instructions below will help you make sure your CSV or Text file is formatted correctly to be imported as a TaticView data sourcedatasource.
<!--T:2-->'''You can download a sample file here: [http[Special://wiki.taticview.com/taticfilesFilePath/Sales.csv |Sales.csv]]'''
<!--T:3-->
'''If you still have problems importing, try [[Importing Problems]].'''
==== Headers ====<!--T:4-->
<!--T:5-->
Headers are not mandatory, but if present they should be contained in just one row (the first one). For example:
<!--T:6-->
[[File:Header csv.png|link=]]
==== Expressions (Formulas) ====<!--T:7-->
<!--T:8-->When importing CSV or text files, we also support creating [[Expressions|Expressions (Formulas)]] as well as Excel files.
<!--T:9-->
To consider expressions in CSV files, the composition of the expression must be in the header line of the data.
<!--T:10-->
Below is an example of a spreadsheet containing two expressions (''Avg Price'' and ''% Profit''):
<!--T:11-->
[[File:Expression header csv.png|link=]]
<!--T:12-->
To create expressions in CSV files the following rules must be observed:
* The expression must begin with the character '''equal''' and character, be enclosed in '''parentheses'''and the columns enclosed in '''quotation''' marks. Examples: ''=("Price"/"Quantity")'', ''=(("Profit"*100)/"Price")''* To reference other columns in the file, use the double-quoted column/header name
* It is not necessary to have data in the other rows for expression columns, as the content will be the result of the expression
<!--T:13-->
In the import screen the expressions will be recognized as the example below:
<!--T:14-->
[[File:Expression csv file.png|link=]]
<!--T:15-->
TaticView will suggest the column position in the file as the expression name. Change as needed.
</translate>