Although “CSV” means “Comma-Separated Values”, Alpana supports other separators than comma :
- Comma : “
- Semicolon : “
- Space : “
- Tab : “
Selecting Connection Type
In the “Create Connection” dialog change the Connection “Type” by selecting “CSV” :
Click to browse for a CSV file.
The decimal separator can be changed depending on the csv localization. It’s possible to choose comma “
, “ or dot “
The CSV Connection presents a single object in the schema : a table with the same name as the file.
Data fields type
Since CSV doesn’t allow to create explicit data types, Alpana has to detect the data types of fields.
If this automatic detection is incorrect, you can always change the data type in the Data Source : Changing Column Type
Data refresh and Buffer
The CSV Connector is bufferized.
If you need to get new data, see Chapter The data Buffer