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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Why do we need Input rows count in tAggregateSortedRow component?

Hi,
I'm little surprised reason behind Input rows count in tAggregateSortedRow component. Could you please let me know the purpose of Input rows count in tAggregateSortedRow component.
When i use Input rows count value as ((Integer)globalMap.get("tFixedFlowInput_1_NB_LINE")) in tAggregateSortedRow component. I'm getting a null pointer exception.
Could you please provide me the reason for null pointer exception.
Labels (2)
3 Replies
Anonymous
Not applicable
Author

The number of records is necessary to recognize the last record reaching the tAggregateSortedRow. 
The component has to send the last group outside the flow loop because if the input component simply sends its last record the tAggregateSortedRow component does not get an idea about this is the last one and would otherwise does not send the last group.
Talend has solved this be expecting the group size. Another approach could be to send a kind of end-record and let the component know "that's it" .
Now it is clear the tAggregateSortedRow needs this count at the beginning of the processing. You have used a counter for this which will be filled at the end of the processing!
Anonymous
Not applicable
Author

Hi,
What would be best way to provide the record count?
Thanks,
Nithin
Anonymous
Not applicable
Author

You do not need to fetch it before starting the flow.
Or if it is to difficult, use the tAggregateRow component, this component does not depends on the knowledge of the row count.