You can use the Dataview tab to review the data that is imported in your data garden. In addition to the content of your data file, information regarding the import itself is recorded as well.
The variables (or columns) that are automatically generated are:
sys_imports: this column is a record count. A subsequent number is assigned to each new record in your import.
sys_importbatch: this column keeps track of the number of imports that have been performed. It also acts as an unique identifier of all records that belong to a single import.
sys_createdon: in this column a date and time stamp is added to register at what specific moment the import has been performed.
Every column name in your dataview, created by you or the system, provides the option to sort or filter the column.
Just click on the column name to open the sort and filter menu. This provides a lot of flexibility to review your data.
In the top right corner of your dataview, it is mentioned how many records are selected or shown. By default, only the first 20 records are shown in your screen.
When you scroll down, an additional 20 are loaded. To load an additional 20, scroll down again, and so forth.
After selecting one or more records, the 'Action' button at the top right corner will become available, providing an option to delete the selected records.
A quick overview of your imported data
The horizontal rows of your dataview are referred to as records.
The vertical rows (columns) in your dataview are referred to as variables.
As a summary, the widget in your data garden will reflect the total number or records as well as the total number of variables present within your data set.
At the bottom of the widget, it mentions how many records where uploaded during the last import and the date at which that import has taken place.