Choose top N values by groups

[#1]

Hi, everyone. May be anyone know how to get table with top N values by groups during load data?

[#2]

return this

https://drive.google.com/file/d/0B1D9cwJJCyZ2QVk0Q3JFbV9qRk0/view?usp=sharing

[swuehl]

Are you using a table box to view your data?

The table box will only show distinct combinations of field values, so it will not show any duplicates.

Since the rank will create a new field, this might add the "distinctness" to your records.

Please check your source data, I assume that your source data already shows the duplicates (e.g. add a Rowno() in your script or a Count(ID) as expression in a straight table)

Other than that, your records don't seem to be sorted correctly when ranked, right?

Again, if possible, post some sample data that can be imported into QV.

[#4]

I used count. If I load data without autonumber - all is ok, but if I use it, some fields dulicates.

The sorting is correct.

Unfortunately, I have no way to send real data.

[swuehl]

Not sure what you mean with that.

Uploading a Sample

I asked for some real data to look at, for example the data you are already showing in your linked images, but we need to look at the source data that and your script.

[#6]

You are rigth. The reason was in the data.