(warning) The Data Prep (Paxata) documentation is now available on the DataRobot public documentation site. See the Data Prep section for user documentation and connector information. After the 2021.2 SP1 release, the content on this site will be removed and replaced with a link to the DataRobot public documentation site.

Export a Dataset

Use

This article will help you learn how to export your datasets and AnswerSets out of Paxata® to a connected data source.


Introduction

Datasets and AnswerSets can be exported out of Paxata to a file on your computer or to a connected data source. Exporting your data gives you the flexibility to share your data with other people or other systems.


Export a dataset

Follow these steps to export a dataset or AnswerSet.

StepAction
1

On the Library screen, hover the cursor over the dataset you want to export.

Result: The dataset actions appear.
2

Click the Export button that displays

Result: The Exporting Dataset page appears.
3

Select the location to export the file to:

To export to ...Then ...
Your computerClick Download locally.
A connected data sourceSelect the data source from the Select Data Source drop-down.


Result: The Export Settings panel appears.

4Adjust the settings as needed.
5

Click Export.

Result: The dataset is exported to the location you specified.

Adjust the export settings

The export settings allow you to define the structure of your dataset for export. The settings available for a dataset depend on the format you’ve chosen for the export. For specific information about a setting, hover your cursor over the help tip.

The following are a few of the frequent and more basic settings you can adjust:

To change the ...Then ...
Format of the datasetSelect the format you want to apply to the dataset from the Format drop-down.
Name of the datasetType the new name in the Name field.

Character set used

Note: From an English character set to Japanese character set

Select a different character encoding from the Character Encoding drop-down.

Note: The byte order mark (BOM), also known as the unicode signature BOM, particularly applies to extended character sets like UTF-16 and UTF-32.

Glossary

The following definitions for terms used in this document.

TermDefinition
AnswerSetLike a dataset except that it is the published result of your data prep
Base datasetThe data on which all other action in the Project will be performed
Data sourceThe source of your dataset
DatasetData that is imported into the Data Library is called a dataset
FiltergramThe combination of the functionality of filters with the power of histograms