Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-04-07 11:56 AM

[resolved] Simple Count

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    |
'--------'

Thank you in advance.
Labels (2)
Labels
948 Views
0 Likes
1 Solution

Accepted Solutions
Anonymous
Not applicable
‎2015-04-10 02:51 AM
Author

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

View solution in original post

948 Views
0 Likes
11 Replies
Anonymous
Not applicable
‎2015-04-07 12:06 PM
Author

Hi 
String type is incompatible for count function, try to convert it to Integer/int type before tAggregateRow component.
Best regards
Shong
788 Views
0 Likes
Anonymous
Not applicable
‎2015-04-07 12:11 PM
Author

Hi shong
This did not work, the ID is alpha numeric and therefore not an integer.
I guess I am trying to gain an understanding on how to complete this without altering my source code by adding a column with the value 1 in each row. This to me as an easy way out and I feel Talend must be able to perform a simple count on a column containing records that have a string data type.
Thank you
788 Views
0 Likes
Anonymous
Not applicable
‎2015-04-07 12:15 PM
Author

Hi 
Can you please upload a screenshot of settings of tAggregateRow? It will be helpful for us to address the issue.
788 Views
0 Likes
Anonymous
Not applicable
‎2015-04-07 12:32 PM
Author

Hi Shong.
Here it is.
  0683p000009MDHp.png
788 Views
0 Likes
Anonymous
Not applicable
‎2015-04-07 10:19 PM
Author

Hi
You have to define one group column.
788 Views
0 Likes
Anonymous
Not applicable
‎2015-04-08 04:13 AM
Author

Hi Shong
I see, but I don't want to group.
I just want an overall total. I.E. 
.--------.
|tLogRow_1|
|=-------|
|DriverID|
|=-------|
|5755 |
'--------'
I'm not sure i'm doing it the right way, I know this would be useful knowing the number of rows that are in a table before they are processed. Is there no easy way to achieve this?
Thanks
788 Views
0 Likes
Anonymous
Not applicable
‎2015-04-08 08:28 AM
Author

Hi Ricco,
What i understood here,you want know the total row count of table before processing data into flow.
Then use "((Integer)globalMap.get("tFileInputDelimited_2_NB_LINE"))" global variable.
Thanks
kumar
788 Views
0 Likes
Anonymous
Not applicable
‎2015-04-08 05:39 PM
Author

Hi 
You can execute a query on txxxInput such as tMysqlInput to counts the number of rows, for example:
"select count(DriverID) from yourTableName"
And define one column with int type on the schema of tMysqlInput.
Best regards
Shong
788 Views
0 Likes
Anonymous
Not applicable
‎2015-04-09 08:08 AM
Author

Hi Shong
We are actually moving away from MS and towards Talend which is one of the reasons why I am looking to complete this simple exercise using Talend. The other reason I am trying to complete this solely using talend is to look at some simple jobs that I feel would be straightforward in SSMS/SSIS and how I could transfer these skills in Talend just to gauge my training requirements.
Thanks
788 Views
0 Likes