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?