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?