Number of identical records in one column

[Anonymous]

Hello!

I am just learning and can't unserstand one thing:
Can create in LOAD a calculated field - that would count all occurrences in a column of values.
I read about count function but as i understood it works when table could be groupped by one column. In my table I have a field ID and i just need to have a value of occurrences in one field.

For example: how can i create third field of occurrences like i do in excel?

I would be very grateful if someone can help me with it.

[devarasu07 · Accepted solution]

Table:

LOAD * Inline [

    id,Word

    1,nsd

    2,ppr

    3,nsd

    4,It

    5,ppr

    6,nsd

    7,pcd

    8,It

];

Join(Table)

LOAD Word,

  Count(Word) as Count

Resident Table

Group By Word;

[Anonymous]

Thank you! It works.