Hello,
I am trying to make a data export like this:
| Selected classification: SITC Rev.4 |
|
| Selected
commodities: 784 (Parts and accessories of the motor vehicles of groups 722,
781, 782 and 783) |
Selected
reporters: ASEAN, Asia, Europe, North Africa, North America, Oceania, OPEC, Other Africa
|
|
| Selected
years: 2007 |
|
Selected
partners: ASEAN, Asia, Europe, North Africa, North America, Oceania, OPEC, Other Africa
|
| Selected
trade flows: Import, Export |
|
My problem is in the results:
I often become two ore more outputs for one relationship, p.e.
| Period |
Trade Flow |
Reporter |
Partner |
Code |
Trade Value |
NetWeight (kg) |
Quantity Unit |
Trade Quantity |
Flag |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2007 |
Export |
ASEAN |
Asia |
784 |
3.394.081.615 |
372.255.444 |
1 |
N/A |
4 |
| 2007 |
Export |
ASEAN |
Asia |
784 |
129.828.794 |
23.399.647 |
8 |
23.399.647 |
6 |
| 2007 |
Export |
ASEAN |
Europe |
784 |
120.976.019 |
10.953.430 |
1 |
N/A |
4 |
| 2007 |
Export |
ASEAN |
Europe |
784 |
183.339.524 |
22.358.254 |
8 |
22.358.254 |
6 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
what should I do? Should I add the Trade Values? Should I ignore on of the output data?
And Second, can I find country group definitions online?
It would be great to become some support.
Kind Regards Peter B