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
Count of column which is varchar datatype
Moderators: chulett, rschirm, roy
What output are you getting in PX and have you tried it with a 1-node configuration file?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
ArndW wrote:What output are you getting in PX and have you tried it with a 1-node configuration file? ...
Yes, actually i tried with execution mode as sequential also ,but giving same out put
col1 | count_col2
abc | 0
abc1 | 0
abc3 | 0
is it possible to take a count of varchar column?
regards,
cmunikoti
Re: Count of column which is varchar datatype
use a filter stage to filter-out based on col2 non-null value. then try aggregating