Thank you, for your help, appreciate it very much.
I copied the code, but replaced the inline load of the area table with this code. The result is that the dissolve table only contains value for one salesarea. For the other Salesarea no record was made.
I tried several sorting options, but that does not seem to solve this, Allthough it is not always the same "SalesArea" a record was made.
areas:
load * inline
[
State, SalesArea
'Afghanistan',South Asia
'Albania',South East Europe
'Algeria',Northern Africa
'American Samoa',Pacific
'Andorra',South West Europe
'Angola',Southern Africa
'Anguilla',West Indies
'Antigua and Barbuda',West Indies
'Argentina',South America
'Armenia',South West Asia
'Aruba',West Indies
'Australia',Pacific
'Austria',Central Europe
'Azerbaijan',South West Asia
'Bahamas, The',West Indies
'Bahrain',South West Asia
'Bangladesh',South Asia
'Barbados',West Indies
'Belarus',Eastern Europe
'Belgium',Western Europe
'Belize',Central America
'Benin',Western Africa
'Bermuda',West Indies
'Bhutan',South Asia
'Bolivia',South America
'Bosnia and Herzegovina',South East Europe
'Botswana',Southern Africa
'Brazil',South America
'British Virgin Islands',West Indies
'Brunei',South East Asia
'Bulgaria',South East Europe
'Burkina Faso',Western Africa
'Burundi',Central Africa
'Cambodia',South East Asia
'Cameroon',Western Africa
'Canada',North America
'Cape Verde',Western Africa
'Cayman Islands',West Indies
'Central African Republic',Central Africa
'Chad',Central Africa
'Chile',South America
'China',East Asia
'Christmas Island',South East Asia
'Cocos (Keeling) Islands',South East Asia
'Colombia',South America
'Comoros',Indian Ocean
'Congo, Republic of the',Central Africa
'Cook Islands',Pacific
'Costa Rica',Central America
'Cote d'Ivoire',Western Africa
'Croatia',South East Europe
'Cuba',West Indies
'Cyprus',South West Asia
'Czech Republic',Central Europe
'Denmark',Northern Europe
'Djibouti',Eastern Africa
'Dominica',West Indies
'Dominican Republic',West Indies
'Ecuador',South America
'Egypt',Northern Africa
'El Salvador',Central America
'Equatorial Guinea',Western Africa
'Eritrea',Eastern Africa
'Estonia',Eastern Europe
'Ethiopia',Eastern Africa
'Falkland Islands (Islas Malvinas)',South America
'Faroe Islands',Northern Europe
'Fiji',Pacific
'Finland',Northern Europe
'France',Western Europe
'French Guiana',South America
'French Polynesia',Pacific
'Gabon',Western Africa
'Gambia, The',Western Africa
'Georgia',South West Asia
'Germany',Western Europe
'Ghana',Western Africa
'Gibraltar',South West Europe
'Greece',South East Europe
'Greenland',North America
'Grenada',West Indies
'Guadeloupe',West Indies
'Guam',Pacific
'Guatemala',Central America
'Guernsey',Western Europe
'Guinea',Western Africa
'Guinea-Bissau',Western Africa
'Guyana',South America
'Haiti',West Indies
'Holy See (Vatican City)',Southern Europe
'Honduras',Central America
'Hungary',Central Europe
'Iceland',Northern Europe
'India',South Asia
'Indonesia',South East Asia
'Iran',South West Asia
'Iraq',South West Asia
'Ireland',Western Europe
'Israel',South West Asia
'Italy',Southern Europe
'Jamaica',West Indies
'Jan Mayen',Northern Europe
'Japan',East Asia
'Jersey',Western Europe
'Jordan',South West Asia
'Kazakhstan',Central Asia
'Kenya',Eastern Africa
'Kiribati',Pacific
'Korea, North',East Asia
'Korea, South',East Asia
'Kuwait',South West Asia
'Kyrgyzstan',Central Asia
'Laos',South East Asia
'Latvia',Eastern Europe
'Lebanon',South West Asia
'Lesotho',Southern Africa
'Liberia',Western Africa
'Libya',Northern Africa
'Liechtenstein',Central Europe
'Lithuania',Eastern Europe
'Luxembourg',Western Europe
'Macedonia',South East Europe
'Madagascar',Indian Ocean
'Malawi',Southern Africa
'Malaysia',South East Asia
'Maldives',South Asia
'Mali',Western Africa
'Malta',Southern Europe
'Man, Isle of',Western Europe
'Marshall Islands',Pacific
'Martinique',West Indies
'Mauritania',Western Africa
'Mauritius',Indian Ocean
'Mayotte',Indian Ocean
'Mexico',Central America
'Micronesia, Federated States of',Pacific
'Moldova',Eastern Europe
'Monaco',Western Europe
'Mongolia',Northern Asia
'Montserrat',West Indies
'Morocco',Northern Africa
'Mozambique',Southern Africa
'Myanmar (Burma)',South East Asia
'Namibia',Southern Africa
'Nauru',Pacific
'Nepal',South Asia
'Netherlands Antilles',West Indies
'Netherlands',Western Europe
'New Caledonia',Pacific
'New Zealand',Pacific
'Nicaragua',Central America
'Niger',Western Africa
'Nigeria',Western Africa
'Niue',Pacific
'Norfolk Island',Pacific
'Northern Mariana Islands',Pacific
'Norway',Northern Europe
'Oman',South West Asia
'Pakistan',South Asia
'Palau',Pacific
'Palestine',South West Asia
'Panama',Central America
'Papua New Guinea',Pacific
'Paraguay',South America
'Peru',South America
'Philippines',South East Asia
'Pitcairn Islands',Pacific
'Poland',Eastern Europe
'Portugal',South West Europe
'Puerto Rico',West Indies
'Qatar',South West Asia
'Reunion',Indian Ocean
'Romania',South East Europe
'Russia',Northern Asia
'Rwanda',Central Africa
'Saint Kitts and Nevis',West Indies
'Saint Lucia',West Indies
'Saint Pierre and Miquelon',North America
'Saint Vincent and the Grenadines',West Indies
'San Marino',Southern Europe
'Sao Tome and Principe',Western Africa
'Saudi Arabia',South West Asia
'Senegal',Western Africa
'Serbia and Montenegro',South East Europe
'Seychelles',Indian Ocean
'Sierra Leone',Western Africa
'Singapore',South East Asia
'Slovakia',Central Europe
'Slovenia',South East Europe
'Solomon Islands',Pacific
'Somalia',Eastern Africa
'South Africa',Southern Africa
'Spain',South West Europe
'Sri Lanka',South Asia
'Sudan',Northern Africa
'Suriname',South America
'Svalbard',Northern Europe
'Swaziland',Southern Africa
'Sweden',Northern Europe
'Switzerland',Central Europe
'Syria',South West Asia
'Taiwan',East Asia
'Tajikistan',Central Asia
'Tanzania',Eastern Africa
'Thailand',South East Asia
'Togo',Western Africa
'Tokelau',Pacific
'Tonga',Pacific
'Trinidad and Tobago',West Indies
'Tunisia',Northern Africa
'Turkey',South West Asia
'Turkmenistan',Central Asia
'Turks and Caicos Islands',West Indies
'Tuvalu',Pacific
'Uganda',Eastern Africa
'Ukraine',Eastern Europe
'United Arab Emirates',South West Asia
'United Kingdom',Western Europe
'United States',North America
'Uruguay',South America
'Uzbekistan',Central Asia
'Vanuatu',Pacific
'Venezuela',South America
'Vietnam',South East Asia
'Virgin Islands',West Indies
'Wallis and Futuna',Pacific
'Western Sahara',Northern Africa
'Western Samoa',Pacific
'Yemen',South West Asia
'Zaire (Dem Rep of Congo)',Central Africa
'Zambia',Southern Africa
'Zimbabwe',Southern Africa
];
