Create and Configure a New Dataset
Prerequisites
Before you can create a new dataset, or configure it, you need access to both a CSV data file and a JSON metadata file. Make sure that the data in the CSV file is well-formed and does not contain any illegal characters. In particular, do not use the forward slash character (/) because it can break the load process and result in errors during scoring.
Overview
In Analytics Builder, creating a new dataset involves assigning a new dataset name, providing the metadata skeleton that will be used to structure the dataset, and loading the set of data records that will be contained in the new dataset.
To Create a Dataset
1. Click DATA in the left navigation panel to make sure the Datasets list page is open.
2. At the top of the Datasets page, click New.
The New Dataset dialog box opens.
3. In the Dataset Name field, enter a name for the new dataset (preferably with no spaces).
4. For the Dataset Field Configuration file, click Choose File and navigate to a stored JSON file containing the configuration information. It provides the metadata skeleton used to structure the data you load into the dataset.
5. For the Dataset Data file, click Choose File and navigate to a stored CSV file containing the data to be uploaded. If the data file includes column headers, click the Dataset Has Header check box.
6. Click Submit to begin the upload.
Status messages will be displayed in the Status Message field and then the dialog box will close. The Datasets list page will be redisplayed with the new dataset in the list.
For a demonstration of the dataset creation process, see the following video:
ThingWorx Analytics – Upload Data.