Count the number of days

Seven Stars

Count the number of days

Hi there are set of dates 


1.2018-04-09  | A  | 1 

2. 2018-04-09 | A | 1

3.2018-04-10 | A |

4.2018-04-09 | B |  1  

5. 2018-04-09 | B |  1

6.2018-04-10 | B |  2 


How do i get the count based on the column string received and populate in the count column

Sixteen Stars

Re: Count the number of days

Use the tAggregateRow and group by your date and string_received fields. You will need to use the count function in the output. Take a look here:


This will group your data so you will lose rows. If you want to keep your rows you can always carry out this calculation and then join the result back to your original dataset to carry across the count.

Seven Stars

Re: Count the number of days

Hi @rhall_2_0 


Using taggregaterow is taking too much ram which makes the system very slower do u have any other solution other than this ? 

Sixteen Stars

Re: Count the number of days

How much data is being processed and have you tweaked your job's RAM settings? There are other ways to do this, but using the tAggregateRow should work pretty well.


To increase the RAM for the Studio you can follow this...


To increase the RAM for just your job you can follow this...


If you need to use a different method, you can use a tJavaFlex and a bit of Java code using a HashMap to achieve this count. It will use less memory, but will require a bit more of a complicated configuration.



Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.