Regarding Infotables

[Bhanu_Manoj]

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.

[anarwal · Accepted solution]

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