Difference between revisions of "Tabular Data Manager"
| Line 71: | Line 71: | ||
[[Image:tabular_data_manager_normalize_result1.png|frame|center|Tabular Data Manager, normalize result]] | [[Image:tabular_data_manager_normalize_result1.png|frame|center|Tabular Data Manager, normalize result]] | ||
| + | === Denormalize === | ||
| + | For example, the following Tabular Resource: | ||
| + | [[Image:tabular_data_manager_denormalize1.png|frame|center|Tabular Data Manager, denormalize]] | ||
| + | when normalized setting as normalized column name 'Year', as value column name 'Quantity' and with columns to normalize '1998', '1999' and '2000' is transformed in: | ||
| + | |||
| + | [[Image:tabular_data_manager_denormalize_result1.png|frame|center|Tabular Data Manager, denormalize result]] | ||
Revision as of 17:57, 28 January 2015
This is the user guide to Tabular Data Manager portlet.
Overview
Tabular Data Manager offers facilities supporting the management of the entire life-cycle(creation, curation, manipulation and publication) of Tabular Resources such as datasets, codelist or generic table. i.e. tabular data representing observations of a given event or phenomenon at different time intervals. Tabular Resource are used in many domains ranging from statistics to signal processing and econometrics. Tabular Data Manager offers a rich set of facilities ranging from those supporting the assessment of data correctness to those supporting the verification of the compliance of data with given code lists, the aggregation and filtering of data.
Basic of Interface
Composition of interface :
- Ribbon menu
- The interface offer on top a ribbon menu, it consists of tabs: Home, Curation, Modify and Analyse.
- Tools area
- The interface offer on left side a tab panel in which the manipolation tools will be activated.
- Main area
- The interface offer on center side a panel in which the grids with data be activated.
Basic Operation
The basic operations are those that enable interaction with a tabular resource and are: open, close, delete, properties and clone.
Open
For open a tabular resource yuo must click on ribbon Home and so in group File you select open button. A window will show the list of tabular resource available to the user.
Close
Tabular resource can be closed looking in the main area and clicking on the x next to its name. To close all open tabular resource go into the ribbon menu, home group, and click on close all button.
Delete
Properties
Clone
Grid Menu
Grid Header Column Menu
Grid Context Menu
Import
CSV
SDMX
Export
CSV
JSON
SDMX
Curation
Normalize
For example, the following Tabular Resource:
when normalized setting as normalized column name 'Year', as value column name 'Quantity' and with columns to normalize '1998', '1999' and '2000' is transformed in:
Denormalize
For example, the following Tabular Resource:
when normalized setting as normalized column name 'Year', as value column name 'Quantity' and with columns to normalize '1998', '1999' and '2000' is transformed in:
