Page History
...
- Drag the Delimited File option from the input step list.
Configure the step to extract data from the file. Use the table below to understand the different fields in the Configure panel.
Expand title Delimited file configuration fields Configuration Setting Explanation Protocol
Choose the file protocol here. For example, you can define if this is a local file, a file on the shared network, FTP or SFTP.
File path
Enter the path to the file.
Note: If you have selected to import a local file, the file should be local on your server.
Advanced settings
This link reveals more setting options, discussed below.
First row contains unique titles
Enable this toggle switch if the first row of the file contains titles or column names. If switched on, the system will read these values as the column field titles.
Field separator
Choose a character from the list to use it to separate values in the CSV, or enter a custom one after selecting the Other option.
Decimal separator
Choose a character from the list to set it as the decimal separator, or enter a custom one after selecting the Other option.
File encoding
Select a file encoding option.
Precision
Use this to specify how many rows of the CVS file Yellowfin will examine in order to define the field types and size. - Low Precision is fast, and only examines the first 1000 rows of the file.
- High Precision is slower, depending on the size of the file, as it examines all rows.
Then click Apply. Data extracted from the file will appear in the data preview panel.
...