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-->
==== 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-->
<!--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: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>
