Copy a dataset
Copying a dataset to your workbook allows you to create a workbook version of datasets from your ArcGIS organization, a database connection, or other data sources. Copied datasets are functionally equivalent to datasets created from files or hosted feature layers. A copied dataset is only available in the workbook where it was copied, unless it is shared to create a hosted feature layer.
Use the following steps to copy a dataset:
- Add a dataset to your workbook, if necessary.
-
Click the Dataset options button
for the dataset in the data pane.
- Click Copy to Workbook.
A copy of the dataset is added to the data pane. The dataset is named in the format Dataset Name 1.
Why copy a dataset?
Tables from database connections and remote feature layers do not have the full functionality of a file, hosted feature layer, or copied dataset. Copying the data to your workbook allows you to take full advantage of all features available in Insights, regardless of your data type.
Copying your data is recommended in the following situations:
- When using a remote feature layer for the following unsupported functions:
- Create a relationship
- Apply and advanced filter
- Apply a cross filter
- Create a binned map
- Create a chart using median or percentile as the statistic
- Use date/time subfields
- When creating a relationship between datasets stored in different database types or data stores.