Page History

...

1. Drag the Delimited File option from the input step list. 
   Image Removed
   Image Added
   
   

2. Configure the step to extract data from the file. First select the file protocol.

   
   
   
   

3.  If the file to be imported is available locally, choose the Local option and drag it into the specified area (or click on it to browse and select the file).

   Note
   If you have selected to import a local file, the file should be local on your server.

   
   
   

4. But to use a file that's available on a network, select the correct protocol (Network Share, FTP, or SFTP), then provide connection details to connect to the network.
   
   
   
   
   
   

5. You can also provide additional configuration settings by enabling the Advanced Settings toggle.
   
   
   
   

   • 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.

6. Finally, click Apply. Data extracted from the file will appear in the data preview panel.
   
   

...

Report

1. Drag Extend the input steps panel and drag the Report input step onto the transformation canvas.
   
   Image Added
   
   
2. Search for the report that you want to extract data from, by entering and then clicking on its name.
   
   
   
   
3. Once a report is selected, its column field names will be displayed.
   
   
   
   
4. Click on the Add Report button.
5. The report fields can be customized in the Configure panel.
   
   
   
   
6. You can remove fields that you don’t want included.
7. If the report has any embedded user-prompt filters, they will also appear here. You can apply these filters when extracting data.
8. Then click Apply. You can see the extracted data from the report in the data preview panel. 
   
   
   

...