You can import data from a flat file into your Arcadia Enterprise instance. Arcadia Enterprise processes this data as a new table, adding it to an existing data repository. You can then use it as a source of supplemental information for existing datasets, by creating new table joins. You can also create a new dataset that references the imported data as a primary table.
The following steps demonstrate how to import data from flat files. The files may be
comma-delimited, or use other delimiting characters. This exercise uses the data from the
downloadable table state-area.csv import data into [data source
samples.state_area
].
On the main navigation bar, click Data.
The Data view appears, open on the Datasets tab.
Click the supplemental menu, and then click Import Data in the drop-down.
The Import Data from File modal window appears.
In the Import Data from File modal window, click Choose File.
Using your computer's native browser, find and select the data file.
Confirm file selection.
In the Import Data from File modal window, note that the name of
the file you added. In this example, we are adding state-area.csv
.
Click Get Data.
In the main area, under Imported File: sate-area.csv, ensure that your data is configured correctly before confirming its import:
samples
.
Alternatively, select another database.state_area
. The
system typically assigns a numerical suffix that you can remove.[Optional] You may select to change the name of the table column before importing.
In this example, we could change the column names state to land_area_sq_miles.
Click Apply Changes to ensure that all adjustments you made (file name, data type, name change, and so on) register.
Click Confirm Import.
Click Confirm Import.
To verify that the data has been imported correctly into your system, check the Connection Explorer interface. Note that the state-area table is visible in our connection.
Typically, we use the Import Data functionality to supplement existing datasets; we add this data by creating joins in the data model.
Depending on your business case, you may instead choose to create a new dataset based on the data you just imported.