DSXchange

I am sure this must be something already discussed, but I just cant find any posts in the forum.

Is not possible to count rows and sum columns in the same Aggregator stage?

Due to Aggregation Type property, you always have to choose between 'Calculation' (where there is no calculation for counting, the most similar I found was Weighting column) and 'Count Rows'

Is not possible to do both, as you do in typical SQL queries?

select count(*), sum(col1), sum(col2) from table

Thanks a lot!

It would seem not, I just played around with the aggregator stage and couldn't find a way of doing with just one stage. Perhaps someone else has found another solution.

add a column before with value "1" , then sum

yimwai - that's a simple and elegant solution

ArndW wrote:yimwai - that's a simple and elegant solution

I agree, I guess I will do this!