TSB logo

Obtain Top Partners

Expand / Collapse
 

Obtain Top Partners


Obtaining top partners from trade data with multiple reporters, years and trade flows cannot be done directly from UN Comtrade.  However, it can be done using MS Access (or other database tools).  The first step is to download the raw data from UN Comtrade which will serve as your data input for your MS Access (or other database tools) query.

Data input:
Select few reporters in 2000-2002, export-import to/from all partners, and commodity=TOTAL.
As an example, please see database table Comtrade_trade_data in the attachment, which was imported from comtrade_trade_data.csv, downloaded from UN Comtrade (also found in the attachment).

SQL query:
See 'Get Top 5 Partners' query in the attached database template.  This will generate the top 5 partners by reporter, year, and flow against the Comtrade_trade_data table.  You can also view the report "Top 5 Partners" to see results of this query.



Rate this Article:

Attachments


comtrade_trade_data.xls comtrade_trade_data.xls (784.00 KB, 2,643 views)

top partners.mdb top partners.mdb (1.13 MB, 1,842 views)

Related Links



Add Your Comments


Name: *
Email Address:
Web Address:
   
  
 
 
   
Verification Code:
*
 

Details
Last Modified:Monday, January 18, 2010
Last Modified By: comtrade_admin
Type: HOWTO
Article not rated yet.
Article has been viewed 5,645 times.
Options