HELP - Need Count() Group By

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need help...

I have internal (qv) tables

(by this command:

tabA:

load ID, surname, name Resident tab1;

tabB:

load ID,knr Resident tab8;)

tabA:

surname / name / ID

Dred / Michal / 1

Vrb / Martin/ 2

tabB:

ID / knr

1 / 6421385

1 / 8655642

2 / 3621586

1 / 7846587

and now need table now, where will be count knr per person, so:

tabX:

surname / name / ID / Count()

Dred / Michal / 1 / 3

Vrb / Martin / 2 / 1

Any idea what type to script for this new tabX?

When I typed "load ID, Count(knr) ...." system writes in column number 4 (real Count(knr), but bad in my case).

Help ...

Re: HELP - Need Count() Group By

Fri, 10 Jun 2016 13:55:45 GMT

this command resolved it:

tab9:

load distinct ID,Count(knr) as count Resident tab Group By ID;

and then leftjoin table with surname, name, ID.