Regarding Infotables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Regarding Infotables
Hi Team,
I have an infotable with a single column. for example the column name is fruits. There are multiple entries in the infotable and there are duplicate entries also. I need to get the count of occurance of each value in the infotable. I know I can use distinct function to get unique records in the column. Later i can loop through the infotable comparing the unique string and increasing a count variable. But what I want is to know if there is any way to get count of "orange" in below infotable using inbuilt function.
Example infotable records :
orange
apple
apple
orange
lemon
I need output like
apple 2
orange 2
lemon 1.
Solved! Go to Solution.
- Labels:
-
Best Practices
-
Coding
-
Examples
-
TWX Dev Portal
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Bhanu_Manoj , You can use var result = Resources["InfoTableFunctions"].Aggregate(params); to count the number values of columns but I do not think it will count the number of particular value appears.
Regards
Ankur
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Bhanu_Manoj , You can use var result = Resources["InfoTableFunctions"].Aggregate(params); to count the number values of columns but I do not think it will count the number of particular value appears.
Regards
Ankur