Yellowfin's CSV functionality allows business users to transform their existing spreadsheets into reports. This means that any of Yellowfin's reporting capabilities can be quickly applied to spreadsheet contents, including the ability to drill down and categorise data.
Yellowfin allows spreadsheet data (stored as CSVs) to be imported into a specified data source and used for reporting. There are two methods for importing CSV data to use for report building;
- Create a report based on a CSV file
- Create a table, through a view, based on a CSV file
Selecting the Import Method
When importing a CSV file for reporting use, it’s important to consider what the data will be used for, and which import method would best suit that use.
If the CSV has been developed for stand-alone use, or the CSV data needs to be stored in a separate data source from other reporting data, and the desired reporting results can easily be achieved with advanced sub query functionality, then the report import method should be used.
If the CSV data is to be used in conjunction with tables from a reporting data source, the view import method should be used.