Hello I just really wanted to make sure I understand the Count functionality within the tAggregateRow component. I have a simple job: tMSSqlinput ---> tAggregateRow ---> tLogRow So, I have a SQL input that returns an ID (String DataType), fed into the aggregate to perform a count and output into the tLogRow. I get the following error and empty table. Can anyone tell me why this is please?
Warning:the operation 'count' for the output column 'DriverID' can't be processed because of incompatible input and/or output types .--------. |tLogRow_1| |=------=| |DriverID| |=------=| |null | '--------'
I see, but you just need to execute a query to count the number of rows and judge it to decide the next step. If you want to see how the count functionality of tAggregateRow works, you have to set a group element, if there is no group element avaiable in your case, simply add a new column and set it with a fixed value on tMap before tAggregateRow, and set the new column as group element on tAggregateRow. For example:
tMssqlInput--main--tMap--tAggregateRow--main--tLogRow
on tMap, add a new column in the output table, and set a fixed value to it, eg:1
Best regards
Shong
