FileDataFormat
FileType
Recognized file formats are:
- CSV for Delimited
- FIX for Fixed Record
- DIF for Data Interchange Format
- EXCEL_BIFF for Microsoft Excel (XLS)
- EXCEL_OOXML for Microsoft Excel (XLSX)
- HTML for HTML
- QVD for QVD file
- XML for XML
- QVX for QVX file
- JSON for JSON format
- KML for KML file
- PARQUET for PARQUET file
Properties
Name | Description | Type |
---|---|---|
qType |
Type of the file. One of:
|
String |
qLabel |
One of:
|
String |
qQuote |
One of:
This property is used for delimited files. |
String |
qComment |
String that marks the beginning of the comment line. Example: “#” or “//” The engine ignores the commented lines during the data load. This property is only used for delimited files. |
String |
qDelimiter | DelimiterInfo | |
qCodePage |
Character set used in the file. |
Integer |
qHeaderSize |
Size of the header. Example: If the header size is 2, the first two rows in the file are considered as header and not as data. The header can contain the field names. |
Integer |
qRecordSize |
Record length. Each record (row of data) contains a number of columns with a fixed field size. This property is used for fixed record data files. |
Integer |
qTabSize |
Number of spaces that one tab character represents in the table file. This property is used for fixed record data files. |
Integer |
qIgnoreEOF |
Is set to true, the end-of-file character is not taken into account during reload. This property is used for delimited files and fixed record data files. |
Boolean |
qFixedWidthDelimiters |
Positions of the field breaks in the table. This property is used for fixed record data files. |
String |
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!