Skip to main content
1-Visitor
November 20, 2020
Solved

Regarding Infotables

  • November 20, 2020
  • 1 reply
  • 1118 views

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.

Best answer by anarwal

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

1 reply

anarwal5-Regular MemberAnswer
5-Regular Member
November 20, 2020

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