I'm come back with other problem :(, by working on qvd table also if I'm using District command during extraction I continue to see a lot of records with same idcode, this because in other columns I could have different values.
I have already tried to use:
Load District id
Firstvalue(....) As ...
Firstvalur(...) As ...
....
From
Group by id;
The problem is here because inside i have a lot of records (900k more or less) and this process take a lot of time to loading all data.
Exist one process more faster ?
n.b. : I have other column (date) where can help me to select the right row..
