The examples below all involve the Mergent Global Fundamentals dataset, specifically the MER/F1 table. This particular table is filterable on multiple columns, including
reportdate. This means that users can narrow down their request to rows with specific values for these (and all available) filters.
The tables API is limited to 10,000 rows per call. However, when using the R library, appending the argument
paginate=TRUE will extend the limit to 1,000,000 rows. As such, we recommend using
paginate=TRUE for all calls. Please note that some datasets can return more data than R allows. If this occurs, you will need to further filter your call to download less data, as outlined in the examples below. Or you may consider using Quandl's data exporter.
It is possible to download only certain desired rows from a table by specifying one or more columns to act as criteria to filter rows. If the value in a given column matches the filter argument, then the row containing that value is returned.
Only columns designated as filterable in the table's documentation page can be used as criteria to filter rows.
Download data for Nokia (
data <- Quandl.datatable('MER/F1', compnumber="39102")
data <- Quandl.datatable('MER/F1', compnumber=c("39102" , "2438"))
It is possible to select specific table columns to download by identifying them with the
data <- Quandl.datatable('MER/F1',qopts.columns="compnumber")
data <- Quandl.datatable('MER/F1',qopts.columns=c("compnumber", "ticker"))
data <- Quandl.datatable('MER/F1',compnumber="39102",qopts.columns="reportdate")
data <- Quandl.datatable('MER/F1',compnumber="39102",qopts.columns=c("reportdate", "indicator", "amount"))
data <- Quandl.datatable('MER/F1', paginate=TRUE)
This is the syntax for calling an entire table. While most tables can be downloaded with such a call, MER/F1's size requires that you narrow down your request with filters, as shown above.