Dataset Function
Dataset Function
Description
The Dataset function makes it easy to load data from NetSuite datasets. Data is returned as a dynamic array, which makes it seamless to integrate with Power Query for more advanced data modeling.
Function Arguments
| Argument Name | Input Information | Required |
|---|---|---|
| Dataset Id | The name of the dataset to query. If the dataset name is not unique, then the dataset id must be specified instead. | Yes |
| Omit Header | If TRUE, then the header row is omitted in the result. | No |
| Skip | Number of records to skip. If omitted, no records are skipped. | No |
| Take | Number of records to return/take. If omitted, all records are returned. | No |
Remarks
Datasets in NetSuite are predefined data views that can be queried directly. This function provides a convenient way to access dataset data without needing to write SuiteQL queries.
Example
Let's say you have a Dataset in NetSuite that contains sales data that you'd like to pull into Excel for analysis.
- Identify the Dataset name or ID in NetSuite.
- In Excel, select Functions > Dataset
- Input the Dataset name or ID as the Dataset Id argument.
- Select Enter to see the data returned as a dynamic array.
Note: Arrays in Excel have blue outlines. If the array cannot fit in the given cell range, it will be marked with #SPILL. Learn more about Arrays (opens in new tab).