Hi there are set of dates
1.2018-04-09 | A | 1
2. 2018-04-09 | A | 1
3.2018-04-10 | A | 2
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
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: https://help.talend.com/reader/hm5FaPiiOP31nUYHph0JwQ/yj8JuBj57qWaYoFqIewUiA
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.
Using taggregaterow is taking too much ram which makes the system very slower do u have any other solution other than this ?
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...https://community.talend.com/t5/Migration-Configuration-and/Allocating-more-memory-to-Talend-Studio/...
To increase the RAM for just your job you can follow this...https://help.talend.com/reader/mhqCkTBnin7IXmJBUJoocQ/vdAWcdjBpxoiN0aM6d9Oyw
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.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.