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

_AnonymousUser — Fri, 02 Oct 2015 17:42:07 GMT

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?

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

Anonymous — Sun, 11 Oct 2015 04:56:57 GMT

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

topic using tAggregate function to get the count of date and boolean columns in Talend Studio

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

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