Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
did you try count distict function in tAggregateRow function
https://help.talend.com/reader/TcF_dD4peTBK89AdRm4onA/tk_I~aj8~5YKSIyHCukhSQ
did you try count distict function in tAggregateRow function
https://help.talend.com/reader/TcF_dD4peTBK89AdRm4onA/tk_I~aj8~5YKSIyHCukhSQ