topic [resolved] tAggregate count in Talend Studio

[resolved] tAggregate count

Anonymous — Fri, 17 Jun 2016 15:01:44 GMT

Hi everybody,
I got an Excel file with two columns "name" and "gender" and in my job there is a tAggregate, it count the number of men.
My problem is that there is no men in my file and in the tAggragate's output there is nothing but i want a 0 in the output!
Is there someone know how to do this?
thanks

Re: [resolved] tAggregate count

Anonymous — Mon, 20 Jun 2016 08:35:18 GMT

Hi,
Did you get "null" string in your actual result?
Would you mind posting your tAggregateRow component setting screenshot into forum? Could you please elaborate your case with an example with input and expected output values so that we can see if there is any workaround for your use case.
Best regards
Sabrina

Re: [resolved] tAggregate count

Anonymous — Mon, 20 Jun 2016 10:37:12 GMT

Hi,
here is my taggregate
it count the number of employee which are using "windows xp" but no one use it so in the output i got this but i want this
Mallee

Re: [resolved] tAggregate count

Anonymous — Mon, 20 Jun 2016 11:36:38 GMT

I have the same problem:

Name;Gender
A;male
B;male
C;male

I want to get this output:

Gender;Count
male;3
female;0

Re: [resolved] tAggregate count

Anonymous — Fri, 24 Jun 2016 09:13:51 GMT

I solved it this way:

tFileInputDelimited:
Name; Gender
Anna;female
Beth;female
Carol;female

tFixedFlowInput:
Gender;Count
female;0
male;0

tAggregates:
tAggregateRow_1: group by Gender and count the rows
tAggregateRow_2: group by Gender and sum up the Count column

Result:
female;3
male;0

Re: [resolved] tAggregate count

Anonymous — Fri, 24 Jun 2016 11:48:29 GMT

thank you!!!!