Numeration of values is in a group

[#1]

There is a datasheet with two fields: for example country and city. It is necessary to add the third field with the number of city within the country. In other words, it is nesessary to renumber cities on separate countries. My decision of task looks enough difficult, may be I did not notice some quite simple method?

[#2 · Accepted solution]

you can use this code in your editscript dialogue

load country,
count(distinct city) as cities
from x.csv group by country;

regards

tauqueer