Advanced Query The Result Table
You can view the results by clicking on the Magnifying Glass in the Status window.
Information is organized in rows and contains the following fields:
|
Column Heading |
Description |
|
|
Nomen |
is the nomenclature used; |
|
|
Reporter |
is the 3-digit alphabetic country code for reporters; |
|
|
Reporter Name |
is the full name of the reporting country; |
|
|
Partner |
is the 3-digit alphabetic country code for partners; |
|
|
Partner Name |
is the full name of the partner country; |
|
|
Year |
is the year of the data; |
|
|
Product |
is the product code based on your selected product nomenclature; |
|
|
Product Name |
provides the description for each product code; |
|
|
Flow name |
is the name of the trade flow; |
|
|
Trade Value |
is given in thousands of US dollars; |
Rows are sorted first by Nomenclature, then by Reporter, Partner, Year, Product and Flow. This table can't be sorted by clicking on a column's heading. You will see in the next topic how to customize the output table.
Filtering the output table window
You can filter the data based on some criteria. For columns with text content like Nomenclature Name, Reporter Name etc you can do a filter by searching for text containing or equal to your filter criteria for that column. For numeric and date columns you can filter based on the following criteria (I) equal to (ii) greater than and (iii) less than. To filter data enter the filter criteria below the column header and click on the Funnel icon and select the filter criteria. You can filter across multiple columns by setting filter criteria.
Closing the output table window
To close the output table window, click on the Close button.
Request Download
Results can be downloaded by clicking on the download icon (down arrow) in the View and Request Download screen. You will be shown a screen to enter a Job Name, Job Description, File Format csv, excel 97-2003 or tab separated, Columns to be downloaded" and optional pivot details for the download job. Click on Download button to request download or Cancel button to cancel the download request. Once you click on download button you will get an option to go to the Download Results screen to download the data. The download results screen will show you the download job name and once the status is complete you can click on the Save icon to download the data. This screen also gives you details on the size of the file to be downloaded.
Doing so opens a Windows Save As screen which allows the specification of the Directory on your computer where the output is to be saved along with the file type (Excel [xls], Tab [txt] or Comma [csv] delimited) and a name.
Next: Customizing Output Tables
WITS Online Help
The World Bank, 2010