DSXchange

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,

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.

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 -

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

metadata1 wrote: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.

nsm wrote: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?

Nagaraj wrote: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.

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

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

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

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

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

kishore2456 wrote: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....