topic Re: How to do count distinct function through taggregator in Talend Studio

How to do count distinct function through taggregator

Anonymous — Sat, 23 Mar 2019 12:26:05 GMT

Hi I have data like below.

Product_ID	COUNTRY	BUSINESS_RULE	Attribute
2	IN	A	Product ID
2	IN	B	Product ID
8	IN	B	Model
31	US	B	Model
31	US	B	Price

From this need country wise distinct count of product. I tried through taggregator , but that provide only count of product where group by Country. As option Tuniquerow may help if for Product and country then use taggregator . But is this any opotion to get count distinct directly.

Re: How to do count distinct function through taggregator

akumar2301 — Sat, 23 Mar 2019 18:50:35 GMT

did you try count distict function in tAggregateRow function

https://help.talend.com/reader/TcF_dD4peTBK89AdRm4onA/tk_I~aj8~5YKSIyHCukhSQ

Re: How to do count distinct function through taggregator

Anonymous — Sun, 24 Mar 2019 02:31:13 GMT

Thanks Abhishek.. Yeah that is working.