[resolved] tAggregate count

[Anonymous]

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 

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

thank you!!!!