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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to do count distinct function through taggregator

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.

 

 

Labels (1)
  • v7.x

1 Solution

Accepted Solutions
akumar2301
Specialist II
Specialist II

2 Replies
akumar2301
Specialist II
Specialist II

did you try count distict function in tAggregateRow function

 

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

Anonymous
Not applicable
Author

Thanks Abhishek.. Yeah that is working.