How to use the "Basic Selection" feature in the Data Query?
Basic Selection is a sub-menu of "Data Query" in the UN Comtrade database.
This feature allows the user to build a query by selecting items from provided lists. This is considered as a traditional data selection tool.
Note: Basic Selection only in Internet Explorer v 6.0 and above.
Two methods for Basic Selection:
Method 1: Load Save Query (available only for subscribers)
You can load your saved query in 'step 0'
Method 2: Input/Select basic items query
Step 1 (Required): Select the commodity classification you are searching for. Description of the classification and its commodities listing can be found at:
Should you need more information on how to choose the commodity classification, please refer to the following KB article: Which classification system is appropriate to use?
Step 2: Enter selection items
Commodities: Allows one to search for commodity by ‘commodity code’ or by ‘item/description’. For example you can search for ‘steel’ in HS2002. Searching by name yields several results and the user has the option to choose one or more which appear in the Select Items column. See figure below:
If you want to load your favorites, choose the right source in step.1. Special Items source enables selection of TOTAL, 1 digit code, 2 digit codes … etc. Reporters, Partners, Years
: Select one or more of each and click the ‘add’ button. Others
: This feature allows one to select the trade flow, filter by value, select a preset sort order, and choose the aggregation option desired. NOTE: Currently only one trade flow can be saved if you choose to save your query
. Also, AutoBatch can be set to ‘full’ or ‘incremental’. Step 3: Save Query (optional)
You can save your query
for future use, and enable notification or AutoBatch.
Please review the following article regarding the above features for save query
: http://unstats.un.org/unsd/tradekb/Knowledgebase/Saved-Query-Alert-and-NotificationRelated questions:
Q: I often get "NO RECORDS", when running the data extraction. What could I do to avoid it?
A: Since not every country reports its trade data in the same classification, you have to make sure which classification is available for which countries or commodities or years. Please use "Data Availability" menu.