Count of column which is varchar datatype
Posted: Tue Sep 29, 2009 4:26 am
I have an issue .i got input as
col1 | col2
abc | y
abc | NULL
abc1 | y
abc1 | y
abc1 | NULL
abc3 | y
i want ouput as
col1 | count_col2
abc | 1
abc1 | 2
abc3 | 1
I used aggregator stage and used "count of non missing value" on the column "col2".i am getting output as
col1 | count_col2
abc | 0
abc1 | 0
abc3 | 0
in server edition i am getting the right output but can't i do the same in PX?
help me out
regards,
cmunikoti
col1 | col2
abc | y
abc | NULL
abc1 | y
abc1 | y
abc1 | NULL
abc3 | y
i want ouput as
col1 | count_col2
abc | 1
abc1 | 2
abc3 | 1
I used aggregator stage and used "count of non missing value" on the column "col2".i am getting output as
col1 | count_col2
abc | 0
abc1 | 0
abc3 | 0
in server edition i am getting the right output but can't i do the same in PX?
help me out
regards,
cmunikoti