using tAggregate function to get the count of date and boolean columns

One Star

using tAggregate function to get the count of date and boolean columns

Hi -
I am trying to get the count of date and Boolean columns using the tAggregateRow component. However I am unable to get the count and store the value in a BigInt/Integer column in the target. The count function in tAggregateRow components appears to work seamlessly for other columns with different datatypes.
Eg:
TableName
Col1 bigint
Col2 bigint
Col3 Boolean
Col4 Date
Upon doing the count operation in tAggregateRow on Col3 and Col4 i am receiving the below error and null value in my target.
Warning:the operation 'count' for the output column 'Col3' can't be processed because of incompatible input and/or output types

Warning:the operation 'count' for the output column 'Col4' can't be processed because of incompatible input and/or output types
Is there a way to let Talend know that the output of the aggregate value may or maynot be the same datatype as the source and create a output only port to store the value of the aggregate output?
Community Manager

Re: using tAggregate function to get the count of date and boolean columns

Hi 
What's the data type of column that stores the result of count operation? Can you please upload a screenshot of your tAggregateRow settings?
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business