repeated data not getting count

[sagarrahul]

hii i am having problem in this

below is a column of my table

in this total count is 19 but i am getting only 15 count  of it

in this repeated data is not getting counted

so please help me in this

and give me a code as soon as possible

CODE

M51.9

M54.5

S62.3

S92.7

S92.7

S72.9

S02.2

S02.2

S42.4

S72.4

S42.0

S42.4

S42.4

S52.9

S42.4

S42.4

S82.2

S82.7

S92.3

[MK_QSL]

Add below while loading in script.

RowNo() as ID

[sunny_talwar]

Are you doing a distinct count or Count? I think a simple count should get you 19

Count(CODE)

[PrashantSangle]

Hi,

Simple count(Code) must work.

kind Regards,

[trdandamudi]

May be this:

Source_Data:

Load * Inline [

CODE

M51.9

M54.5

S62.3

S92.7

S92.7

S72.9

S02.2

S02.2

S42.4

S72.4

S42.0

S42.4

S42.4

S52.9

S42.4

S42.4

S82.2

S82.7

S92.3

];

NoConcatenate

Final:

Load

RowNo() as RowNumber,

CODE

Resident Source_Data;

Drop Table Source_Data;

[sagarrahul]

its not working

i am using just count(code) still its not coming 

[sagarrahul]

i do not want to load this filed can you suggest other options

[settu_periasamy]

Hi sagar,

The count(CODE) is working. check the attachment..

[ajsjoshua]

Hi,

If normal count is not working try counting with aggr

=sum(aggr(count(code),id))

PFA

Regards,

Joshua.