11,856
edits
Changes
Updating to match new version of source page
<languages/>
The instructions below will help you make sure your CSV or Text file is formatted correctly to be imported as a TaticView data sourcedatasource.
'''You can download a sample file here: [http[Special://wiki.taticview.com/taticfilesFilePath/Sales.csv |Sales.csv]]'''
'''If you still have problems importing, try [[Importing Problems]].'''
==== Expressions (Formulas) ====
When importing CSV or text files, we also support creating [[Expressions|Expressions (Formulas)]] as well as Excel files.
To consider expressions in CSV files, the composition of the expression must be in the header line of the data.
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
In the import screen the expressions will be recognized as the example below:
[[File:Expression csv file.png|link=]] TaticView will suggest the column position in the file as the expression name. Change as needed.