CSV is considered to be an industry standard for data analysis. The most common ways of producing CSV data are:
- export from Excel
- export from databases
CSV stands for comma-separated values so a simple CSV file looks the following way:
Product,Price Apple,2.50 Cherry,5.25
Connect to CSV via UI
Step 1. Go to the Connect tab () on the Toolbar.
Step 2. Choose to which CSV you want to connect:
- To local CSV. Use this option to load a file from your local file system.
- To remote CSV. Use this option to load a file by its URL.
Here’s an example of connecting to a remote CSV file:
Connect to CSV programmatically
To get your CSV data from a file, specify the file’s URL in the dataSource.filename property:
let pivot = new WebDataRocks({
container: "#wdr-component",
toolbar: true,
report: {
dataSource: {
filename: "URL-to-your-CSV-file"
}
}
});
Specify a custom field separator
In most cases, a comma (,) is used as a separator between different CSV fields, such as Product and Price. WebDataRocks also supports other separators.
If fields in your data are separated by a semicolon (;) such data source can be used without any additional configurations. If fields in your data are separated by some other symbol, e.g., a colon (:), you need to specify fieldSeparator as in the example:
let pivot = new WebDataRocks({
container: "#wdr-component",
toolbar: true,
report: {
dataSource: {
filename: "URL-to-your-CSV-file",
fieldSeparator: ":"
}
}
});