Page History

...

Section

Column Column Anchor menu menu Icon Input source Description Delimited file This input method is used when extracting data from a delimited file (that is, a file with separators). Freehand SQL Use this method to import data from a database using an SQL query. Report Use this method to use a Yellowfin report as the source of data. Single table This input step can be used to import data from a single database table. Single third-party connector To extract data from a third-party connector, such as Twitter, Facebook, Google Analytics, etc.

...

...

Report

...

Report

1. Drag the Report input step onto the transformation canvas.
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 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. 
   
   
   

...

Single Database Table

...

Third-party Connectors

1. Drag the third-party table connector option from the input step onto the canvas.
   
   Image Added
   
   
2. A list of all third-party data sources will appear. (Ensure you have already created a third-party data source. Learn how to do this here.)
   
   Image Added
   
   
3. Choose the data source.
4. Then select the table with the data you wish to use.
5. Finally, click Submit.
   
   Image Added
   
   
6. Next choose the fields that are to be extracted.
7. Note: If you’re extracting data from a Google Analytics table, you will need to provide the start and end date to filter your data.
8. Click on the Apply button. The extracted data will appear in the data preview panel.
   
   Image Added