Sequential file

[kittu.raja]

Hi,

I have a flat file having 2 columns. It look like this
Col1 Col2
1 adam
1 adam
2 adam
3 michael
3 michael

I want to find out the unique count of col1.

Can anybody help me out in doing that.

Thanks,

[Nagaraj]

You can use a unix command something like this(since the file is on unix)

nawk -F'|' '!x[$1]++' chck.txt |wc -l

I hope this is what you are looking for.

[metadata1]

Within a job you could apply Aggregator Stage to group/count records - Have you thought about using that option?

Not sure what your exact requirements are -

[nsm]

simply use:- sort -n -u test|wc -l
and do result-1 as your file ist line is column names.

[kittu.raja]

Within a job you could apply Aggregator Stage to group/count records - Have you thought about using that option?

Not sure what your exact requirements are -

I have used it but I am getting counts of each group. I want all the distict count of the second column.

[kittu.raja]

simply use:- sort -n -u test|wc -l
and do result-1 as your file ist line is column names.

I want only the distinct count of second column. Where are you specifying the second column name?

[kittu.raja]

You can use a unix command something like this(since the file is on unix)

nawk -F'|' '!x[$1]++' chck.txt |wc -l

I hope this is what you are looking for.

Where are you specifying the column name.

[Nagaraj]

$1 is the first field and $2 is the second......so on ....

[dr.murthy]

I

have used it but I am getting counts of each group. I want all the distict count of the second column.

[/quote]

tell me how would be the your output result,means you need the distinct count of second col or frist col

[Nagaraj]

output is just a number, why dont you try the commad which i have given in UNIX?

[kishore2456]

You can use aggregator, where just use aggregation and count on the same column (either first or second which you want).

[kishore2456]

You can use aggregator, where just use aggregation and count on the same column (either first or second which you want).

[Nagaraj]

You can use aggregator, where just use aggregation and count on the same column (either first or second which you want).

I think he is right, you can do this way as well....