Formats

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” :

Connection Parameters

File Path

Click to browse for a CSV file.

Decimal Separator

The decimal separator can be changed depending on the csv localization. It’s possible to choose comma “ , “ or dot “ .

Connection Schema

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

Last modified: Sep 22, 2021

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment